Hi All,
I have a column containing comma separated values of different sizes and my requirement is to turn those into columns.
DB version 19c
I need a dynamic solution which can accept max 500 character string and turn it into columns.
select ‘1, 2, , 3’ from dual should show result as below
c1 c2 c3 c4
1 2 3
select ‘1, 2’ from dual should show result as below
c1 c2
1 2