insert comma separated value into a column.
ora_1978Mar 15 2012 — edited Mar 15 2012I want insert a value 'A','B','C' in a column c1 in table test using an insert statement. How to perform ?
create table test (c1 varchar2(20));
when i say
select c1 from test;
the result should be
'A','B','C'
1 ROW SELECTED.
thanks,
Vinodh