Is there a function to split a string in Oracle PL/SQL?
There is apex_util.string_to_table – see my answer to this question. Also, prior to the existence of the above function, I once posted a solution here on my blog. Update In later versions of APEX, apex_util.string_to_table is deprecated, and a similar function apex_string.split is preferred.