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