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!

Result set like "abc,pqr,xyz" in one string

572110Aug 31 2007 — edited Aug 31 2007
I need output like


select col from....

col
====
abc
xyz
pqr


i need output like "abc,xyz,pqr" in one single string so i can use in

Select * from temp where col in ( One String )

if anyone know how to solve.

TIA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2007
Added on Aug 31 2007
4 comments
561 views