SPOOL IN SQL PLUS

[pando]

SQL> col today new_value mydate
SQL> set escape /
SQL> select sysdate today from dual;

TODAY
---------
2002SEP12

SQL> spool c:\&mydate/SPOOL.txt
SQL> select 1 from dual;

1
----------
1

SQL> spool off