Re: Getting all rows of sqlplus output on one line

AskTom is your friend. See the STRAGG function.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2196162600402

Or, you can write the results into a file and then use the change utility to change every CRLF into ';'.

Adar Yechiel
Rechovot, Israel

Rodd Holman wrote:

However, the tool lets you paste a ";" separated list into it.

--
//www.freelists.org/webpage/oracle-l

References:
- Getting all rows of sqlplus output on one line
  - From: Rodd Holman