Oracle SQL Developer 3.0: SQL*Plus Support

 

Date: March 2011

 

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'