Concatenate query results

I have a parameter based query that returns a single column of names.

Example:

John Smith
Goerge Johnson
Mary Jones
.....
....
....
....
etc.

What I want to do is concatenate these names into a single string;

John Smith, George Johnson, Mary Jones, ..., ..., ..., ..., ect

Thank you!
Regards,
Del
N8OFP
.

Relevant Pages

  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... Senior Oracle DBA ... with the query and modify it to the way I need it and I could not get ... dynamic data back with that said how could I turn this into a dynamic ...
    (comp.databases.oracle.misc)
  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... Another bad habit is to store dates as character strings (rely as well ... with the query and modify it to the way I need it and I could not get ... dynamic data back with that said how could I turn this into a dynamic ...
    (comp.databases.oracle.misc)
  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... Another bad habit is to store dates as character strings (rely as well ... with the query and modify it to the way I need it and I could not get ... dynamic data back with that said how could I turn this into a dynamic ...
    (comp.databases.oracle.misc)
  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... (SELECT ROWNUM RN FROM DUAL CONNECT BY ... oracle documentation or in v$reserved_words. ... The two decodes 'join' the RN from query b) to query a), ...
    (comp.databases.oracle.misc)
  • Re: EDI export
    ... To put each column in one line you'll have to use VBA & a recordset. ... > export a text file from a query or table. ... > It has to all be in a single column. ...
    (microsoft.public.access.queries)