inserting comma-separated values with pl/sql

Hi there,

i have a stored proc which has a varchar parameter which contains a list of values, separated by comma.

e.g.: 123,456,789

what i wanna do is to separate the values and insert them into a table

e.g.

insert into t (f) values (123);
insert into t (f) values (456);
insert into t (f) values (789);

Can this be done with pl/sql? And if i can be done, how? Received on Fri Feb 21 2003 - 13:22:42 CST