Concatenate values separated with commas

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database internals How to find a dropped table? Removing carriage returns at the end of clob fields Finding length of numeric datatype field Problem with incoming parameter in dynamic SQL statement Reading WSID from back-end Making a select statement faster Select * from loc Difference between 9i and 10g OCP exams How to free up more space for Oracle? Error after installation of 9i on Red Hat Linux Oracle and SQL Oracle tutorial library: SearchOracle.com's learning guides Can I specify Oracle column order in my database table? Review: Oracle's 11g R2 database has some good and bad SELECT statement syntax and examples Oracle PL/SQL tutorial PL/SQL datatypes in Oracle Stored procedures in PL/SQL PL/SQL functions and triggers in Oracle Do I need a license for SQL Developer Data Modeler in Oracle? Using the SQL GROUP BY clause for counting combinations Oracle and SQL Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary autonomous transaction  (SearchOracle.com) CFML  (SearchOracle.com) dynamic SQL  (SearchOracle.com) foreign key  (SearchOracle.com) Java Database Connectivity  (SearchOracle.com) Open Database Connectivity  (SearchOracle.com) Oracle  (SearchOracle.com) stored procedure  (SearchOracle.com) The Open Group  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

No, you will need to write a user-defined function with a VARRAY or DECODE for this. Something like this might work:

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;