Commande | Description |
@ | Runs the specified command file. @@ |
@@ | Runs a nested command file. |
/ | Executes the SQL command or PL/SQL block currently stored in the SQL buffer. |
ACCEPT | Reads a line of input and stores it in a given user variable. |
APPEND | Adds specified text to the end of the current line in the buffer. |
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. |
CHANGE | Changes text on the current line in the buffer. |
CLEAR | Resets or erases the current value or setting for the specified option, such as BREAKS or COLUMNS. |
COLUMN | Specifies display attributes for a given column. Or, lists the current display attributes 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 username to ORACLE. |
COPY | Copies data 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. |
DEL | Deletes the current line of the buffer. |
DESCRIBE | Lists the column definitions for the specified table, view, or synonym. |
DISCONNECT | Commits pending changes to the database and logs the current username off ORACLE, but does not exit SQL*Plus. |
EDIT | Invokes a host operating system text editor on the contents of the specified file or on the contents of the buffer. |
EXECUTE | Executes a single PL/SQL statement. |
EXIT | Commits all pending database changes, terminates SQL*Plus, and returns control to the operating system. |
GET | Loads a host operating system file into the buffer. |
HELP | Accesses the SQL*Plus help system. |
HOST | Executes a host operating system command without leaving SQL*Plus. |
INPUT | Adds one or more new lines after the current line in the buffer. |
LIST | Lists one or more lines of the buffer. |
PAUSE | Displays an empty line followed by a line containing text, then waits for the user to press [Return]. Or, displays two empty lines and waits for the user's response. |
PRINT | Lists the current value of a bind variable. |
PROMPT | Sends the specified message or a blank line to the user's screen. |
REMARK | Begins a comment in a command file. |
RUN | Lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. |
RUNFORM | Invokes a SQL*Forms application from within SQL*Plus. |
SAVE | Saves the contents of the buffer in a host operating system file (a command file). |
SET | Establishes an aspect of the SQL*Plus environment for your current session. |
SHOW | Lists the value of a SQL*Plus system variable. |
SPOOL | Stores query results in an operating system file and, optionally, sends the file to a default printer. Also lists the current spooling status. |
SQLPLUS | Starts SQL*Plus from the operating system prompt. |
START | Executes the contents of the specified command file. |
TIMING | Records timing data for an elapsed period of time, lists the current timing area's title and timing data, or lists the number of active timing areas. |
TTITLE | Places and formats a specified title at the top of each report page, or lists the current TTITLE definition. |
UNDEFINE | Deletes a given user variable that you defined either explicitly (with the DEFINE command) or implicitly (with an argument to the START command). |
VARIABLE | Declares a bind variable which can be referenced in PL/SQL. |
WHENEVER OSERROR | Exits SQL*Plus if an OS command generates an error. |
WHENEVER SQLERROR | Exits SQL*Plus if a SQL command or PL/SQL block generates an error. |