Wednesday, July 25, 2007

How to save your oracle work

Use the spool command to view the commands and results you have entered.

SQL>spool on
SQL>spool ex1 (ex1 is the file name where you store your work)
SQL>give your commands
SQL>spool off

Oracle stores all the work in the file ex1 until you give spool off.