Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Feb 02 2005 - 20:11:11 CST