Suppressing newline during a SELECT returning multiple rows

Is there any way for Oracle (using standard SQL rather than PL/SQL) to suppress the newline character when returning a list of rows.

For example, if I have a table EMP with several records. When I issue the statement:

    SELECT name FROM emp

I would like to get a single row output back comprising the following:

  "john, james, jenny, jill, benny"

in other words, all names separated by the a comma followed by space.

Many thanks in advance for you help.

Shuaib Received on Wed Feb 04 2004 - 13:43:24 CET