SQLplus tricks

SQLplus tricks

• see the last command you typed (the command buffer) list
• execute the command buffer run
• edit a command you just typed (edits the command buffer)edit
• execute a command (must end in ;) simply type the command number (1 by default)
• require screen to stop after each page of output set pause on
• set the page size to <nn> set page size <nn>
• find out what tables are available select table_name from tabs

          Note: in MySql the same information can be obtained with
          show tables

• get information about a table (i.e. it's schema) describe <table>
• stop a command that's running for too long Ctrl-C
• run system commands host <command> e.g.host ls
• redirect screen output to a file (including everything you type) spool 'file.txt'

          when done, stop writing to file
          spool off