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