RE: PL/SQL Question - Separating A Delimited String Into temporar y Variables

From: Knight, Jon <jknight_at_concordefs.com>
Date: Wed, 2 Feb 2005 22:59:39 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953261A54B8@memex1.corp.cefs.int>

I seem to remember someone saying that DBMS_UTILITY has a routine to do that. Something like comma_to_tab maybe? I've never used it myself, so let us know what you find.

Jon Knight

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Bass

Sent:	Wednesday, February 02, 2005 7:08 PM
To:	oracle-l_at_freelists.org
Subject:	PL/SQL Question - Separating A Delimited String Into

temporary Variables

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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 03 2005 - 00:02:23 CST