This is the closing page for the SQL⁺. Some miscelleneous items that might be useful are listed here:

• Save your last SQL stmt.

SQL> SAVE [filename]

• Spool the screen to a file

SQL> SPOOL [filename]

the SQL⁺ will start recording your displayed output into your specific [filename] with the default file extension '.lst'. To stop spooling and save the file:

SQL> SPOOL OFF

• Define a favorite editor

Suppose 'emacs' is the editor that you want to use in the SQL⁺

SQL> DEFINE_EDITOR = emacs
SQL> EDIT [filename]

• Some Note:
• You cannot create any duplicate table's and view's name. So drop the old one before creating
• Commit: Oracle's transaction start from your last COMMIT 'til you issue the next COMMIT. No commit, no store (except some commands.: create, drop) 'til you exit the SQL⁺.
• Rollback: rollback till the last commit

Exit to : Oracle Hints and Tips