1. Using Oracle® SQL Developer Web
  2. Supported SQL*Plus and SQLcl Commands

A Supported SQL*Plus and SQLcl Commands

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

A.1 Supported SQL*Plus Commands

SQL Developer Web 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

A.2 Supported SQLcl Commands

SQL Developer Web 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

A.2.1 SODA Commands

Starting from SQL Developer Web release 19.4.2, SODA commands are now supported in SQL Developer Web. 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>