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

• Tweet
• Share
• Share
• Share
• Share

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post