SQL*Plus commands

Brief description of commands specific to SQL * Plus

In SQL * Plus scripts usually run the SQL.

Frequently used commands:


  • SPOOL file - all SQL commands until the command SPOOL OFF will be written to file
  • @file - to run the script file
  • ed file - edit the file in the default editor
  • SPOOL OFF - finishes sending data to a file
  • DESC - displays a description of the structure of the table
  • CONNECT - to connect to the database change
  • EXIT - to exit the program

No comments: