I found the split function below at this URL:
create or replace function split(p_list in varchar2, p_del in varchar2 := ',') return split_tbl pipelined is
l_list varchar2(32767) := p_list;
l_idx := instr(l_list,p_del);
if l_idx > 0 then
l_list := substr(l_list,l_idx+length
It works in that it stores each of the words split out from the longer string are store in a temporary table of sorts. I don't think this table has a name.
Is there a way that I can store theses words in a normal Oracle table so that I can use them again later in the program I am calling the split function in? I want to put the words in a table and sort them by their length (the number of characters in the words).
I'm assigning 500 points to this question since I think its hard and I needed this process to work a few hours ago.