I need a 10g function, type and table type that will enable me to
select * from table(NEW_FUNCTION('value1,value2,value3'));
that will return 3 rows with value1 in the first row, value2 in the second row and value 3 in the third row. It needs to take any length of string up to 4K bytes. I used to use a function like this called ps_parse, but haven't discovered it with recent searches.
Does anyone have this function handy?