how to return comma seperated values in oracle SP
Posted
by john
on Stack Overflow
See other posts from Stack Overflow
or by john
Published on 2010-06-13T04:21:50Z
Indexed on
2010/06/13
4:32 UTC
Read the original article
Hit count: 276
If I have a simple query like:
OPEN cursor FOR
SELECT USER_ID FROM USER_TABLE WHERE USER_ID = V_SOME_USER;
this will return records in different rows but how can I return the rows in the following format:
'userid1', 'userid2', 'userid3'.....'useridN'
I want to do this because I want to send this off as a parameter to another stored procedure...Also, what is the limit on how big the string can be when passed to the SP as parameter
© Stack Overflow or respective owner
