select test_colm from TEST_TABLE ;
1
2
3
4
5
select LISTAGG(test_colm,’,’) within group (order by test_colm)as testcolm from TEST_TABLE
1,2,3,4,5
select test_colm from TEST_TABLE ;
1
2
3
4
5
select LISTAGG(test_colm,’,’) within group (order by test_colm)as testcolm from TEST_TABLE
1,2,3,4,5