Re: Export to a ascii, tab delimited file

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 @my_script > my_spool.txt

will still have the trailing blanks.

Arjan. Received on Wed Dec 02 1998 - 00:00:00 CST