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

Home -> Community -> Usenet -> c.d.o.misc -> Spooling without the whitespace

Spooling without the whitespace

From: BVince2172 <bvince2172_at_aol.comPRO>
Date: 25 Aug 2002 12:56:16 GMT
Message-ID: <20020825085616.29713.00002982@mb-mo.aol.com>


I'm trying to spool to a csv file, which I have managed to do, but I can't work out how to remove the extra white space in the columns. ie, my output looks like the following:

   101,12-Dec-99, 190101,01-Jan-00, 29292,'monkey' , 90

Should I be SETting something or setting something in the COLUMN definition, or something else altogether??

Thanks,
Ben Received on Sun Aug 25 2002 - 07:56:16 CDT

Original text of this message

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