select userid from users where usergrp='1'This query retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any function that could do that.
create or replace function concat( cur sys_refcursor )return varchar2 is retval varchar2(32767); hold varchar2(80);begin loop fetch cur into tmp; exit when cur%notfound; ret := ret || ',' || hold; end loop; return retval;end;/ select distinct substr (concat( cursor( select userid from users outer where e.usergrp = outer.usergrp ) ),1,40) useridsfrom users e;
Dig Deeper on Oracle and SQL
Related Q&A from Don Burleson
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have a barcode application running on a Sun platform with Oracle9i. Oracle is 92% full. I have space in other locations. Is there any way to ... Continue Reading