Re: Creating a delimited text file with SQL*Plus / PL/SQL

air1dah_at_airvax.air.ups.com (DON HOOVER, UNITED PARCEL SERVICE AIRLINE) wrote:
>>>set space 0;
>>>set feedback off;
>>>set pagesize 0;
>>>set heading off;
>>>spool file_name;
 

>>>select column_1||','||colun_2||','||column_3||
>>> from table_name;
 

>>>spool off;
>
>Is there a way to do this and keep the output from coming to standard out?
>I want to do this in a shell script and avoid having the output come to the
>console.
 

>Thanks,
>Don Hoover
>air1dah_at_airaxp.air.ups.com

"set term off"
This works only for commands from a script, not interactive commands

DL Kray Received on Tue Apr 02 1996 - 00:00:00 CEST