Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL Question - Separating A Delimited String Into temporary Variables
Kevin Bass wrote:
>Hello:
>
>I am converting my Perl program into an Oracle package but I have run
>into a small problem. I have been successfully except for a minor
>problem. I would like to separate a value of 1-2-3-4-5-6-7 by the dash,
>into seven separate values. The finish product would turn out to be
>something like val1 = 1, val2 = 2, val3 = 4, etc. Is this possible? If
>so, how can I achieve this? Thanks!
>
>Kevin
>
>
>
Go to asktom.oracle.com and search for stragg - he uses it to separate
commas - easy enough to change to dashes!
Steve
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2005 - 03:09:29 CST