spool - outputing a file with data only
721230Sep 7 2009 — edited Sep 7 2009Hi,
I am using Oracle SQL*PLUS and I am relatively new to this.
I am trying to output a file which have data only and using the below.
SQL> spool on
SQL> spool d:\dept.txt
SQL> select abc from dept where rownum <4;
abc
---------
123
234
345
3 rows selected
SQL> spool off
This actually outputs the entire text from the "select" command till "3 rows selected". Is there a way I can only output the data like
123
234
345
Thanks in advance
Tej