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

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 3 Oct 2007 11:46:05 +0200
Message-ID: <470364e6$0$240$e4fe514c@news.xs4all.nl>

"Carlos" <miotromailcarlos_at_netscape.net> schreef in bericht news:1191399125.012073.89630_at_22g2000hsm.googlegroups.com...
> On 2 oct, 09:36, "Shakespeare" <what..._at_xs4all.nl> wrote:
>> "jobs" <j..._at_webdos.com> schreef in
>> berichtnews:1190991379.524985.162790_at_g4g2000hsf.googlegroups.com...
>>
>> > apparently I can't do this in 9i?
>>
>> > myarray := split(sendto, ',');
>>
>> > Any easy way to do it?
>>
>> > Thanks fo rnay help or information.
>>
>> See a post in this group:
>>
>> news:1190994100.779275.76010_at_g4g2000hsf.googlegroups.com
>>
>> Looks like the answer to your question.
>>
>> Shakespeare
>
> You may take a look here:
>
> http://carlosal.wordpress.com/2007/06/22/convertir-cadenas-a-tablas/
>
> HTH.
>
> Cheers.
>
> Carlos.
>

Magic! I like these LAG/OVER/ORDER BY queries. Can you enhance this one to put the results in an array?

Shakespeare Received on Wed Oct 03 2007 - 04:46:05 CDT