oracle將指令記錄下來---spool

SQL> spool lab.txt

SQL> select sysdate from dual;

SYSDATE
--------------
02-06月-13

SQL> select 1+1 from dual;

       1+1
----------
         2

SQL> select user from dual;

USER
------------------------------------------------------------
SYSTEM

SQL> spool off


那麼會將以上指令，存成lab.txt
存放在C:\\Users\Administrator
(我登入windows用Administatror帳號)