json_table
can be used to turn a (horizontal) comma separated list of values into a (vertical) list or rows. select * from json_table('[1,1,2,3,5,8,13,21]', '$[*]' columns ( num number(2) path '$[*]' )) ; -- -- NUM -- ---------- -- 1 -- 1 -- 2 -- 3 -- 5 -- 8 -- 13 -- 21
json_table
, a comma-separated list (here: 'foo,bar,baz'
) can be turned into a vertical result set like so: select * from json_table('["' || replace('foo,bar,baz', ',', '","') || '"]' , '$[*]' columns nam varchar2(42) path '$[0]' ); -- -- NAM ------ -- foo -- bar -- baz