Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to split a string into tokens

446249Oct 12 2006 — edited Oct 12 2006
Hi. This is a follow-up to a question from yesterday. I've got a string passed to the database that looks like this,

|12345^4.000|45678^3.670|.... -- more records

I'd like to loop over the string and be able to pick up each "record" and insert into a table. A record would be ID 12345 and value 4.000. Another record would be ID 45678 and value 3.670. How can I accomplish this? Your help is very much appreciated. Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2006
Added on Oct 12 2006
6 comments
923 views