2.1 Alphabetic List of SQLcl Commands
@{url | file_name[.ext]} [arg ...]
@@ { url | file_name[.ext] } [arg ...]
/ (slash)
ACC[EPT] variable [NUM[BER] | CHAR | DATE | BINARY_FLOAT | BINARY_DOUBLE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text | NOPR[OMPT]] [HIDE]
ALIAS [<name>=<SQL statement>;| LOAD [<filename>]|SAVE [<filename>] | LIST [<NAME>] | DROP <name> | DESC <name> <Description String>]
APEX [export <application_id>]
A[PPEND] text
ARCHIVE LOG LIST
ARG[UMENT] OPTIONS See Defining Parameters in SQLcl Scripts Using the ARGUMENT Command
BRE[AK] [ON report_element [action [action]]] ...
BRIDGE
BTI[TLE] [printspec [text | variable] ...] | [ON | OFF]
CD [<directory>]
C[HANGE] sepchar old [sepchar [new [sepchar]]]
CL[EAR] option ...
COL[UMN] [{column | expr} [option ...]]
COMP[UTE] [function [LAB[EL] text] ... OF {expr | column | alias} ...ON {expr | column | alias | REPORT | ROW} ...]
CONN[ECT] [{<logon>| / |proxy} [AS {SYSOPER | SYSDBA | SYSASM}] [edition=value]]
CTAS table new_table
COPY {FROM database | TO database | FROM database TO database} {APPEND | CREATE | INSERT | REPLACE | APPEND_BYTE | CREATE_BYTE | REPLACE_BYTE} destination_table[(column, column, column, ...)] USING query
DDL [object_name [type] [SAVE filename]]
DEF[INE] [variable] | [variable = text]
DEL [n | n m | n * | n LAST | * | * n | * LAST | LAST]
DESC[RIBE] {[schema.]object[@connect_identifier]}
DG
DISC[ONNECT]
ED[IT] [file_name[.ext]]
EXEC[UTE] statement
{EXIT | QUIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]
FIND [<filename>]
FORMAT [BUFFER | RULES <filename> | FILE <input_file> <output_file>]
GET [FILE] file_name[.ext] [LIST | NOLIST]
HELP | ? [topic]
HISTORY [index | FULL | USAGE | SCRIPT | TIME | CLEAR (SESSION)?]
HO[ST] [command]
INFO[RMATION] {[schema.]object[@connect_identifier]}
I[NPUT] [text]
L[IST] [n | n m | n * | n LAST | * | * n | * LAST | LAST]
LOAD [schema.]table_name[@db_link] file_name
OERR <facility> <error>
PASSW[ORD] [username]
PAU[SE] [text]
PRINT [variable ...]
PRO[MPT] [text]
{QUIT | EXIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]
REM[ARK]
REPEAT <iterations> <sleep>
REST [export [<module_name> | <module_prefix>] | modules | privileges | schemas]
R[UN]
SAV[E] [FILE] file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]]
SCRIPT <script file>
SET system_variable value
SHO[W] [option]
SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
SODA
SPO[OL] [filename[.ext] [CRE[ATE] | REP[LACE] | APP[END]] | OFF | OUT]
SSHTUNNEL <username>@<hostname> -i <identity_file> [-L localPort:Remotehost:RemotePort]
STA[RT] { url | file_name[.ext] } [arg ...]
STARTUP db_options | cdb_options | upgrade_options
STORE {SET} file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]]
TNSPING <address>
TTI[TLE] [printspec [text | variable] ...] | [ON | OFF]
UNDEF[INE] variable ...
WHENEVER OSERROR {EXIT [SUCCESS | FAILURE | n | variable | :BindVariable] [COMMIT | ROLLBACK] | CONTINUE[COMMIT | ROLLBACK | NONE]}
WHENEVER SQLERROR {EXIT [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK] | CONTINUE [COMMIT | ROLLBACK | NONE]}
WHICH <filename>
XQUERY xquery_statement
Note:
You can use the up and down arrow keys to cycle through the previous 100 statements or scripts.