| Log in to SQL*Plus |
SQLPLUS [ { username[/passward][@connect_identifier] | / }
[ AS { SYSDBA | SYSOPER } ]
| /NOLOG
]
|
| List help topics available in SQL*Plus |
HELP [ INDEX | topic ]
|
| Execute host commands |
HOST [ command ]
|
| Show SQL*Plus system variables or environment settings |
SHOW { ALL | ERRORS | USER | system_variable | ... }
|
| Alter SQL*Plus system variables or environment settings |
SET system_variable value
|
| Start up a database |
STARTUP PFILE = filename
[ MOUNT [ dbname ] | NOMOUNT | ... ]
|
| Connect to a database |
CONNECT [ [ username [ /password ] [ @connect_identifier ]
[ / AS { SYSOPER | SYSDBA } ]
]
|
| List column definitions for a table, view, or synonym, or specifications for a function or procedure |
DESCRIBE [ schema. ] object
|
| Edit contents of the SQL buffer or a file |
EDIT [ filename [ .ext ] ]
|
| Get a file and load its contents into the SQL buffer |
GET filename [ .ext ] [ LIST | NOLLIST ]
|
| Save contents of the SQL buffer to a file |
SAVE filename [ .ext ] [ CREATE | REPLACE | APPEND ]
|
| List contents of the SQL buffer |
LIST [ n | n m | n LAST | ... ]
|
| Delete contents of the SQL buffer |
DEL [ n | n m | n LAST | ... ]
|
| Add new lines following current line in the SQL buffer |
INPUT [ text ]
|
| Append text to end of current line in the SQL buffer |
APPEND text
|
| Find and replace first occurrence of a text string in current line of the SQL buffer |
CHANGE sepchar old [ sepchar [ new [ sepchar ] ] ]
sepchar can be any non-alphanumeric character such as "/" or "!"
|
| Capture query results in a file and, optionally, send contents of file to default printer |
SPOOL [ filename [ .ext ]
[ CREATE | REPLACE | APPEND | OFF | OUT ]
|
| Run SQL*Plus statements stored in a file |
@ { url | filename [ .ext ] } [ arg... ]
START filename [ .ext ] [ arg... ]
.ext can be omitted if the filename extension is .sql
|
| Execute commands stored in the SQL buffer |
/
|
| List and execute commands stored in the SQL buffer |
RUN
|
| Execute a single PL/SQL statement or run a stored procedure |
EXECUTE statement
|
| Disconnect from a database |
DISCONNECT
|
| Shut down a database |
SHUTDOWN [ ABORT | IMMEDIATE | NORMAL | ... ]
|
| Log out of SQL*Plus |
{ EXIT | QUIT }
[ SUCCESS | FAILURE | WARNING | ... ]
[ COMMIT | ROLLBACK ]
|
