Convert string to rows/table
Posted: Mon Feb 22, 2021 6:53 am
select * from table(apex_string.split('1,2,3',','))
select * from table(apex_string.split('1:2:3',':'))
Output will be
1
2
3
select * from table(apex_string.split('1:2:3',':'))
Output will be
1
2
3