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

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.comadd to the above code...

set echo off
set termout off

... Received on Sun Mar 31 1996 - 00:00:00 CET