Is there a function to split a string in plsql?

Question

I need to write a procedure to normalize a record that have multiple tokens concatenated by one char, I need to obtain these tokens splitting the string and insert each one as a new record in a table. Does Oracle have something like a "split" function?

Answer 1

You have to roll your own. E.g.,

http://articles.techrepublic.com.com/5100-10878_11-5259821.html
http://www.builderau.com.au/architect/database/soa/Create-functions-to-join-and-split-strings-in-Oracle/0,339024547,339129882,00.htm

Answer 2

There is apex_utility.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.