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]
|
|
|
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]
|
|
|
exec[ute]
|
|
|
exit
|
Stops execution and reinstates connection in
combobox
|
|
pro[mpt]
|
|
|
quit
|
Stops execution and reinstates connection in
combobox
|
|
rem[ark]
|
|
|
roll[back]
|
|
|
sta[rt]
|
|
|
undef[ine]
|
|
|
whenever
|
|
Bookmark
