Skip to Content
0
Former Member
Jul 01, 2009 at 04:32 PM

SQL spool

422 Views

Hi ,

I am trying to save 1000 records through spool but it is not helping me out, what is the best way of doing so. Here is what i am trying to do.

SQL > Spool test.txt;

SQL> select * from table name;

SQL> spool off;

or

SQL > Spool c:\test.txt;

SQL> select * from table name;

SQL> spool off;

But it doesn't save any file. what to do please help.

thanks