Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Outputting a table/recordset to a csv

Re: Outputting a table/recordset to a csv

From: Guido Konsolke <Guido.Konsolke_at_Triaton.com>
Date: Tue, 22 Oct 2002 08:10:23 +0200
Message-ID: <1035266275.907818@news.thyssen.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US