Skip to Main Content

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 comma separated value into a column.

ora_1978Mar 15 2012 — edited Mar 15 2012
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2012
Added on Mar 15 2012
5 comments
8,429 views