All SQL and PL/SQL commands are supported as they are passed directly from the SQL Worksheet to the Oracle database.
SQL*Plus commands have to be interpreted by the SQL Worksheet before being passed to the database. The SQL Worksheet currently supports a number of SQL*Plus commands. SQL*Plus commands which are not supported by the SQL Worksheet are ignored and are not sent to the Oracle database.
| Command |
Comments |
| @ |
|
| @@ |
|
| acc[ept] |
|
| autotrace |
|
| clear screen |
|
| conn[ect] |
Only valid in the context
of Run Script. Commands in the script after CONNECT will be run
against alternate schema but after completion of script, the SQL
Worksheet is left within the context of the selected Connection. |
| def[ine] |
|
| desc[ribe] |
|
| doc[ument] |
|
| echo |
|
| errors |
|
| esc[ape] |
|
| exec[ute] |
|
| exit |
Stops execution and reinstates connection
in combobox |
| feed[back] |
|
| ho[st] |
|
| pau[se] |
|
| print |
|
| pro[mpt] |
|
| quit |
Stops execution and reinstates connection
in combobox |
| rem[ark] |
|
| roll[back] |
|
| sta[rt] |
|
| term[out] |
|
| timi[ng] |
|
| undef[ine] |
|
| user |
|
| var[iable] |
|
| ver[ify] |
|
| whenever |
|
| xquery |
|
Bookmark
