Oracle SQL Developer 3.0: SQL*Plus Support
Date: March 2011
Supported SQL*Plus Commands
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.
| 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 |
| 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'