Problem with format of query results!!

[LauraJM]

I am trying to write a query in oracle sql, the query itself is a simple SELECT query and produces a list of results, however this list needs to be picked up and used in a front end package. I need to convert the query result list into a comma seperated string to be pulled into the front end package for further manipulation.

Is there a function or any other way to convert the list of results that a query returns into a comma seperated string.

 

[lewisp]

Change your query so that it concatenates the results for you:

[tt]SELECT char_col1 || ',' ||
To_Char(num_col1), || ',' ||
char_col2 || ',' ||
To_Char(date_col1,'DD-MON-YYYY') || ',' ||
..... etc[/tt]