Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outputting a table/recordset to a csv
Hi Aidan,
if I got you right you are looking for a 'Select *...' to spool out. If that's the case, then just add
SET COLSEP ';' to your command list. This will put a semicolon after every column of every row. The other SET commands have been answered by others. Especially Karsten's hint 'Use Trimspool...' may be helpful.
hth,
Guido
Received on Tue Oct 22 2002 - 01:10:23 CDT