Re: Write table columns to an external data file

Try this:

SQL> spool filename.ext
SQL> select name, address_1, address_2, city, state, amt

          from customer;
SQL> spool off

"E. Paul" <pwinston99_at_gsm.uci.edu> wrote in message news:3B5DE550.923C74C8_at_gsm.uci.edu...
> How would I write the result of a select to an external data file?
>
> something like this
>
> select name, address_1, address_2, city, state, amt
> from customer
>
> "to an external ouput file"
>
>
> Thanks in advance
>
Received on Tue Jul 24 2001 - 16:50:16 CDT