Re: PL/SQL Question - Separating A Delimited String Into temporary Variables
- From: Steve Jelfs <steve@xxxxxxxxxxxxxx>
- To: kbass@xxxxxxxxxxxxxxx
- Date: Thu, 03 Feb 2005 08:06:42 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
