Re: Export to a ascii, tab delimited file
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: 1998/12/02
Message-ID: <74412e$1r6$1_at_newton.a2000.nl>#1/1
Date: 1998/12/02
Message-ID: <74412e$1r6$1_at_newton.a2000.nl>#1/1
Thomas Kyte wrote
>set trimspool on
Just for completeness (and please correct me if I'm wrong): this will
not affect the output of normal SQL queries, which might be captured
from SQL*Plus using redirection. Like if my_script is:
set trimspool on
select my_columns
from my_table;
exit
then
sqlplus scott/tiger _at_my_script > my_spool.txt
will still have the trailing blanks.
Arjan. Received on Wed Dec 02 1998 - 00:00:00 CET