This document details the SQL*Plus commands you can use in the Oracle SQL Developer SQL Worksheet. 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. Supported SQL*Plus Commands | Command | Release 1.1 | Release 1.2.1 | Release 1.5 | Release 1.5.5 | Release 2.1 | Release 3.0 | @ | Yes | Yes | Yes | Yes | Yes | Yes | @@ | Yes | Yes | Yes | Yes | Yes | Yes | | / | Yes | Yes | Yes | Yes | Yes | Yes | acc[ept] | Yes | Yes | Yes | Yes | Yes | Yes | | a[ppend] | | | | | | | | archive | | | | | | | | archive log list | | | | | | Yes | | attr[ibute] | | | | | | | | appi[nfo] | | | | | | Yes | | array[size] | | | | | | Yes | | auto[commit] | | | | | | Yes | | copyc[ommit] | | | | | | Yes | | autorecovery | | | | | | Yes | | autotrace | Yes | Yes | Yes | Yes | Yes | Yes | | bre[ak] | | | | | | | | bti[tle] | | | | | | | | clear screen | Yes | Yes | Yes | Yes | Yes | Yes | | c[hange] | | | | | | | | col[ulmn] | | | | | Yes (Limited, see below) | Yes (Limited, see below) | conn[ect] | Yes | Yes | Yes | Yes | Yes | Yes | | comp[ute] | | | | | | | | copy | | | | | | Yes | def[ine] | Yes | Yes | Yes | Yes | Yes | Yes | | del | | | | | | | desc[ribe] | Yes | Yes | Yes | Yes | Yes | Yes | | disc[onnect] | | | | | | | doc[ument] | Yes | Yes | Yes | Yes | Yes | Yes | | echo | Yes | Yes | Yes | Yes | Yes | Yes | | ed[it] | | | | | | | | errors | | Yes | Yes | Yes | Yes | Yes | | esc[ape] | | Yes | Yes | Yes | Yes | Yes | exec[ute] | Yes | Yes | Yes | Yes | Yes | Yes | exit | Yes | Yes | Yes | Yes | Yes | Yes | | feed[back] | Yes | Yes | Yes | Yes | Yes | Yes | | get | | | | | | | | help | | | | | | | | ho[st] | Yes | Yes | Yes | Yes | Yes | Yes | | i[nput] | | | | | | | | l[ist] | | | | | | | | newpage | | | | | | | | null | | | | | | Yes | | oradebug | | | | | | | | pagesize | | | | | | | | passw[ord] | | | | | | Yes | | pau[se] | Yes | Yes | Yes | Yes | Yes | Yes | | print | | Yes | Yes | Yes | Yes | Yes | pro[mpt] | Yes | Yes | Yes | Yes | Yes | Yes | quit | Yes | Yes | Yes | Yes | Yes | Yes | | r[un] | | | | | | | | recover | | | | | | | rem[ark] | Yes | Yes | Yes | Yes | Yes | Yes | | repf[ooter] | | | | | | | | reph[eader] | | | | | | | roll[back] | Yes | Yes | Yes | Yes | Yes | Yes | | sav[e] | | | | | | | sta[rt] | Yes | Yes | Yes | Yes | Yes | Yes | | startup | | | | | | | | sho[w] | | | | | | Yes | | shutdown | | | | | | | | spo[ol] | | | Yes | Yes | Yes | Yes | | store | | | | | | | | term[out] | Yes | Yes | Yes | Yes | Yes | Yes | | timi[ng] | Yes | Yes | Yes | Yes | Yes | Yes | | tti[tle] | | | | | | | undef[ine] | Yes | Yes | Yes | Yes | Yes | Yes | | user | Yes | Yes | Yes | Yes | Yes | Yes | | var[iable] | | Yes | Yes | Yes | Yes | Yes | | ver[ify] | | Yes | Yes | Yes | Yes | Yes | | whenever | Yes | Yes | Yes | Yes | Yes | Yes | xquery | Yes | Yes | Yes | Yes | Yes | Yes | The SQL*Plus column command supports a variety of formatting features. These are not included in the support here. Column support in SQL Developer 2.1 relates to input variable as shown in the example below. column global_name new_value gname
select user global_name from dual;
prompt '&gname' Returns GLOBAL_NAME
------------------------------
HR 1 rows selected old:prompt '&gname'
new:prompt 'HR'
'HR' | 
Developer Tools
Printer View