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.lst
|
| START
| Run a SQL script file (short: @) |
http://www.orafaq.com/faqplus.htm#PLUSCOMMANDS