Home » Other » Client Tools » splitting and associating part of a field
splitting and associating part of a field [message #38640] Thu, 02 May 2002 14:05 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I have a column: col1
The data looks like this: '1=joe,2=some_host,3=someip'
I am trying to separate these values and insert them into their own columns. The twist is that the numbers: 1,2,3 are associated with values in another table. I use the other table to hold column names and a fictitional column id. If substr of val1 (obviously delimited by '=') is equal to 1 then insert it into column a, and so on...I have the first step complete, which is splitting the data and putting it into variables, but I don't am stuck, and am unsure how to perform the association with the new values 1=joe to this other table. My head is spinning so I apologize if I am not making sense.
Somebody please throw me a bone.
Thanks.
Re: splitting and associating part of a field [message #38650 is a reply to message #38640] Fri, 03 May 2002 05:45 Go to previous message
Joe
Messages: 138
Registered: November 1999
Senior Member
Thought I would pass on the information I have gathered. There is a built in function:
dbms_utility.comma_to_table that I am using to accomplish this...
Previous Topic: ORA-00918 : column ambiguously defined. Please help!
Next Topic: Problem with SQL Trace Command
Goto Forum:
  


Current Time: Fri Mar 29 05:35:14 CDT 2024