Re: newbie question - Exporting a query into a text file

Got it!

Many Thanks Jason

Jason Judge wrote:

> Use SQL*Plus with the spool command:
>
> set head off
> set feedback off
> set pagesize 0
> set trimout on
> set trimspool on
> spool myfile.txt
> select name || ',' || address from details;
> spool off
>
> Phong Lam wrote in message <377154F1.69337020_at_us.ibm.com>...
> >Is it possible to run a query in Oracle and then dump it into a flat
> >text file? I'm running 7.3.4
> >
> >Thanks
> >
Received on Fri Jun 25 1999 - 09:29:03 CDT