Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: novice: extract comma delimited data
You can set the linesize in SqlPLus to almost any length....since you are spooling to a text file is does not have to be 'readable' while in SqlPlus, so if you issue the following ( or put them in the sql script )
Set linesize 1500
Set feedback off
set heading off
set pagesize 1000 ( or some other large number, depending on the # of records )
set newpage 0
Then run the query as described by Chris , you will get a clean output file ( mostly, some editing may be needed before use )
The SET commands are powerful tools when creating spooled output...check them out in the SqlPlus docs...
DutcherJG_at_navair.navy.mil (J. G. Dutcher) wrote:
>These are good approaches, but what do you do when the results are wider
>than sqlplus or sql allows? I need to download a file about 1200
>characters per line.
>Any help is appreciated.
>
>TIA
>
>
>
>
Received on Fri Apr 30 1999 - 10:16:38 CDT