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 [, 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}
|{proxy_user [ username ]
[/password] [@connect_identifier]}
]
Note: Brackets in boldface are part of the syntax and do not imply optionality.
|
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 nonalphanumeric ASCII 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 { url | 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 ]
|