Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL Question - Separating A Delimited String Into temporary Variables

Re: PL/SQL Question - Separating A Delimited String Into temporary Variables

From: Steve Jelfs <steve_at_trolltec.co.uk>
Date: Thu, 03 Feb 2005 08:06:42 +0000
Message-ID: <4201DB92.50103@trolltec.co.uk>


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-l
Received on Thu Feb 03 2005 - 03:09:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US