Re: How to store output of Select statement in a file?

If this is being done in SQL*Plus which it looks like it is then you need to spool the output

i.e

SQL> spool output.txt
SQL> SELECT * FROM emp;
SQL> spool off

everything within the spool on and off commands will be written to output.txt.

Cheers,

Paul

P.S. This is my first ever posting so if it goes horribly wrong I apologise in advance. Received on Wed Mar 04 1998 - 00:00:00 CST