Re: Convert query To Text ASCII File

Use the SPOOL command to sent the output to a text file:

SQL> Spool myfile.txt
SQL> select * from emp;
SQL> spool off;

"Alexander T .Agung" wrote:
>
> Hi,
>
> I need help to convert a query result in Oracle 7.3 into an ASCII text
> file.
>
> Alexander T.
Received on Mon Feb 07 2000 - 07:30:22 CST