What are the basic SQL*Plus commands?
The following SQL*Plus commands are available: ACCEPT Get input from the user DEFINE Declare a variable (short: DEF) DESCRIBE Lists the attributes of tables and other objects (short: DESC) EDIT Places you in an editor so you can edit a SQL command (short: ED) EXIT or QUIT Disconnect from the database and terminate SQL*Plus GET Retrieves a SQL file and places it into the SQL buffer HOST Issue an operating system command (short: !) LIST Displays the last command executed/ command in the SQL buffer (short: L) PROMPT Display a text string on the screen. Eg prompt Hello World!!! RUN List and Run the command stored in the SQL buffer (short: /) SAVE Saves command in the SQL buffer to a file. Eg “save x” will create a script file called x.sql SET Modify the SQL*Plus environment eg. SET PAGESIZE 23 SHOW Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc. SPOOL Send output to a file. Eg “spool x” will save STDOUT to a file called x.
Here is a list of some of the most frequently used SQL*Plus commands: • ACCEPT – Get input from the user • DEFINE – Declare a variable (short: DEF) • DESCRIBE – Lists the attributes of tables and other objects (short: DESC) • EDIT – Places you in an editor so you can edit a SQL command (short: ED) • EXIT or QUIT – Disconnect from the database and terminate SQL*Plus • GET – Retrieves a SQL file and places it into the SQL buffer • HOST – Issue an operating system command (short: !) • LIST – Displays the last command executed/ command in the SQL buffer (short: L) • PROMPT – Display a text string on the screen. Eg prompt Hello World!!! • RUN – List and Run the command stored in the SQL buffer (short: /) • SAVE – Saves command in the SQL buffer to a file. Eg “save x” will create a script file called x.sql • SET – Modify the SQL*Plus environment eg. SET PAGESIZE 23 • SHOW – Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc. • SPOOL – Send output to a file. Eg “spool x” wi
