Skip to Main Content
Forums

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!

Insert delimited values to a table

752456Oct 19 2010 — edited Oct 19 2010
Dear All,

table name - Test

columns - id, value

User will give the values through procedure.
store_date('USER','12345,ABC,345789,XXX,53898,UUUU'.....)
User may give up to 60 set of
values through the string with ',' delimited value.

I need to store 12345 to id and ABC to value,
345789 to id and XXX to value and so on.

Please guide me to achieve the same.

Bala

Edited by: user6642575 on Oct 19, 2010 2:43 AM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 16 2010
Added on Oct 19 2010
#pl-sql
5 comments
493 views