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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2006

Added on Oct 12 2006

6 comments

923 views