I want to convert colon delimited list into separate rows. I am passing col1 VARCHAR2(4000) to apex_string.string_to_table.
select (select column_value from table(apex_string.string_to_table(col1))) from tab1;
getting ORA-00902: invalid datatype.
Thanks!!!