Re: Oracle sql function SPLIT?



Alex wrote:

Does it exist?
I need prepared statement like this:
select split(?) from dual
which for parameter like '1 2 3' returns 3 rows
1
2
3
and for parameter 'a b c d' returns 4 rows
a
b
c
d

Any idea how to do this?
Alex.

For an argument that can have any number of entries, it
would take some *very* fancy PL-SQL to do it, if at all possible.
The much better way would be to simply parse the string into
it's bits in java. Why do you need it from the DBMS?
Joe Weinstein at BEA Systems

.