Re: split string into an array by some delimiter using 9i?

jobs wrote:
> apparently I can't do this in 9i?
>
> myarray := split(sendto, ',');
>
> Any easy way to do it?
>
> Thanks fo rnay help or information.

given that split isn't an Oracle syntax why would you think you could write something from one product and it would work in another?

If you can tell us which product you thought Oracle was. And what it does.
I've no doubt we can help.
I could guess that you are trying to turn a comma delimited list into separate strings but that would just be a guess.

If it is a good one try DBMS_UTILITY.COMMA_TO_TABLE http://www.psoug.org/reference/dbms_utility.html but it does have limitations you can find at: http://tahiti.oracle.com

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org