A Supported SQL*Plus and SQLcl Commands in SQL Worksheet

This following sections list the SQL*Plus and SQLcl commands supported in the worksheet.

Supported SQL*Plus Commands

The SQL worksheet supports most of the SQL*Plus commands except those statements that are related to formatting.

  • / (slash)

  • @@ { url | file_name[.ext] } [arg ...]

  • ACC[EPT] variable [NUM[BER] | CHAR | DATE | BINARY_FLOAT | BINARY_DOUBLE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text | NOPR[OMPT]] [HIDE]

  • ARCHIVE LOG LIST

  • BRE[AK] [ON report_element [action [action]]] ...

  • BTI[TLE] [printspec [text | variable] ...] | [ON | OFF]

  • 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} ...]

  • COPY {FROM database | TO database | FROM database TO database} {APPEND | CREATE | INSERT | REPLACE} destination_table[(column, column, column, ...)] USING query

  • DEF[INE] [variable] | [variable = text]

  • DESC[RIBE] {[schema.]object[@connect_identifier]}

  • DISC[ONNECT]

  • EXEC[UTE] statement

  • {EXIT | QUIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]

  • GET [FILE] file_name[.ext] [LIST | NOLIST]

  • HO[ST] [command]

  • L[IST] [n | n m | n * | n LAST | * | * n | * LAST | LAST]

  • PAU[SE] [text]

  • PRINT [variable ...]

  • PRO[MPT] [text]

  • {QUIT | EXIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]

  • R[UN]

  • SAV[E] [FILE] file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]]

  • SET system_variable value

  • SHO[W] [option]

  • SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]

  • STA[RT] { url | file_name[.ext] } [arg ...]

  • STARTUP db_options | cdb_options | upgrade_options

  • TIMI[NG] [START text | SHOW | STOP]

  • TTI[TLE] [printspec [text | variable] ...] | [ON | OFF]

  • UNDEF[INE] variable ...

  • VAR[IABLE] [variable [type][=value]]

  • XQUERY xquery_statement

Parent topic: Supported SQL*Plus and SQLcl Commands in SQL Worksheet

Supported SQLcl Commands

The SQL worksheet supports many of the SQLcl commands.

  • ALIAS

  • APEX

  • BRIDGE

  • CTAS

  • DDL

  • FORMAT

  • INFORMATION

  • LOAD

  • NET

  • OERR

  • RESERVED_WORDS

  • SCRIPT

  • SETERRORL

  • SODA (See SODA Commands)

  • TNSPING

  • TOSUB

  • WHICH

Parent topic: Supported SQL*Plus and SQLcl Commands in SQL Worksheet

SODA Commands

SODA (Simple Oracle Document Access) commands are supported in the SQL code editor. SODA allows schemaless application development using the JSON data model. The commands are:

  • SODA create <collection_name> — Creates a new collection

  • SODA list — Lists all the collections

  • SODA get <collection_name> [-all | -f | -k | -klist] [{<key> | <k1> <k2> ... | <qbe>}] — Lists documents in the collection. Optional arguments:

    • all: Lists the keys of all documents in the collection

    • k: Lists documents matching the specific <key>

    • klist: Lists documents matching the list of keys

    • f: Lists documents matching the <qbe>

  • SODA insert <collection_name> <json_str | filename> — Inserts a new document within a collection

  • SODA drop <collection_name> — Deletes existing collection

  • SODA count <collection_name> [<qbe>] — Counts number of documents inside collection. Optional parameter <qbe> returns number of matching documents

  • SODA replace <collection_name> <oldkey> <new_{str | doc}> — Replaces one document with another

  • SODA remove <collection_name> [-k | -klist | -f] {<key> | <k1> <k2> ...| <qbe>} — Removes documents from collection. Optional arguments:

    • k: Removes document in collection matching the specific <key>

    • klist: Removes document in collection matching the list <key1> <key2> ...

    • f: Removes document in collection matching <qbe>

Parent topic: Supported SQLcl Commands