Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Nother sql question...
I have a list of id's passed in. I need a string of names returned that coincide with those id's. It's very easy to just create a cursor, loop through, and concantenate to the string on every iteration but I was thinking there would be a way to do this in sql with one of the new analytic functions but nothing is really jumping out at me.
Anyone?
tableA
Id Name
1 A
2 B
3 C
Sql>fReturnString(1,2,3);
Sql>a,b,c
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 10 2004 - 13:16:26 CST
![]() |
![]() |