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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to convert result rows into comma separated values

prakashJan 4 2012 — edited Jan 5 2012

hi,

Version

BANNER

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE	11.1.0.7.0	Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Query

Select distinct prcdr_code from procedure p where P.PRCDR_CTGRY_LKPCD='P' ;

Output
-----------
PRCDR_CODE

0001F
0001T
0002F
0002T
0003F
0003T
0004F
0005F
0005T
0006F
0006T
0007F
0007T
0008F
0008T
0009F
0009T
000VA
000VG
.....
...

Desired Output
-------------------
0001F,0001T,0002F,0002T .................


My work
----------------
i tried this .....

Select distinct wm_concat(prcdr_code) as re from procedure p where P.PRCDR_CTGRY_LKPCD='P'  ;

But i got ORA-22813: operand value exceeds system limits error



Please help me ..

Thanks,
P Prakash

Edited by: prakash on Jan 4, 2012 9:05 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2012

Added on Jan 4 2012

14 comments

12,201 views