Re: String list with SQL-Group-Function?

My PL/SQL is a little immature, but the idea might be to actually make your own little procedure/function.

DECLARE
  buffer emp.name%TYPE;

  CURSOR name_cur IS
    ( SELECT name FROM emp );

BEGIN
  DBMS_OUTPUT.ENABLE(1000); FOR name_rec IN name_cur
LOOP
    DBMS_OUTPUT.PUT_LINE (name_rec.name || ', '); END LOOP; END;

--
Michael O'Neill
mjoneill_at_email.com


<kreitsch_at_my-deja.com> wrote in message news:90l3rd$t57$1_at_nnrp1.deja.com...


> DB : Oracle 8i 8.1.5.1

>

> I would like have a function like that

>

> SELECT strcat(name, ',' ) List from emp;

>

> Output :

> List

> --------------------

> Clerk,Otto,Hugo, ...

>

> Thanks for advice

>

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.