SQL*Plus Command Summary

Command	Description
@ ("at" sign)	Runs the SQL*PLus statements in the specified command file. The command file can be called from the local file system or from a web server.
@@ (double "at" sign)	Runs a command file. This command is similar to the @ ("at" sign) command. It is useful for running nested command files because it looks for the specified command file in the same path as the command file from which it was called.
/ (slash)	Executes the SQL command or PL/SQL block.
ARCHIVE LOG	Starts or stops the automatic archiving of online redo log files, manually (explicitly) archives specified redo log files, or displays information about redo log files.
ATTRIBUTE	Specifies display characteristics for a given attribute of an Object Type column, and lists the current display characteristics for a single attribute or all attributes.
BREAK	Specifies where and how formatting will change in a report, or lists the current break definition.
BTITLE	Places and formats a specified title at the bottom of each report page, or lists the current BTITLE definition.
CLEAR	Resets or erases the current clause or setting for the specified option, such as BREAKS or COLUMNS.
COLUMN	Specifies display characteristics for a given column, or lists the current display characteristics for a single column or for all columns.
COMPUTE	Calculates and prints summary lines, using various standard computations, on subsets of selected rows, or lists all COMPUTE definitions.
CONNECT	Connects a given user to Oracle.
COPY	Copies results from a query to a table in a local or remote database.
DEFINE	Specifies a user variable and assigns it a CHAR value, or lists the value and variable type of a single variable or all variables.
DESCRIBE	Lists the column definitions for the specified table, view, or synonym or the specifications for the specified function or procedure.
DISCONNECT	Commits pending changes to the database and logs the current user off Oracle, but does not exit SQL*Plus.
EXECUTE	Executes a single PL/SQL statement.
HELP	Accesses the SQL*Plus help system.
LIST	Lists one or more lines of the SQL buffer.
PASSWORD	Allows a password to be changed without echoing the password on an input device.
PRINT	Displays the current value of a bind variable.
PROMPT	Sends the specified message to the user's screen.
RECOVER	Performs media recovery on one or more tablespaces, one or more datafiles, or the entire database.
REMARK	Begins a comment in a command file.
REPFOOTER	Places and formats a specified report footer at the bottom of each report, or lists the current REPFOOTER definition.
REPHEADER	Places and formats a specified report header at the top of each report, or lists the current REPHEADER definition.
RUN	Lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer.
SET	Sets a system variable to alter the SQL*Plus environment for your current session.
SHOW	Shows the value of a SQL*Plus system variable or the current SQL*Plus environment.
SHUTDOWN	Shuts down a currently running Oracle instance.
START	Executes the contents of the specified command file. The command file can only be called from a uri.
STARTUP	Starts an Oracle instance and optionally mounts and opens a database.
TIMING	Records timing data for an elapsed period of time, lists the current timer's title and timing data, or lists the number of active timers.
TTITLE	Places and formats a specified title at the top of each report page, or lists the current TTITLE definition.
UNDEFINE	Deletes one or more user variables that you defined either explicitly (with the DEFINE command) or implicitly (with an argument to the START command).
VARIABLE	Declares a bind variable that can be referenced in PL/SQL.
WHENEVER OSERROR	Performs the specified action if an operating system command generates an error.
WHENEVER SQLERROR	Performs the specified action if a SQL command or PL/SQL block generates an error.