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!

List to comma separated string.

AChatterjeeNov 4 2010 — edited Nov 4 2010
From below SQl query we can convert string to list.

select column_value val from table(sys.odcivarchar2list('a', 'b', 'c', 'd'));

IS there any similar method to convert a list to varchar, means any function ?

Note - I know using dbms_utility.table_to_comma.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2010
Added on Nov 4 2010
6 comments
2,897 views