Insert delimited values to a table
752456Oct 19 2010 — edited Oct 19 2010Dear 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