Reserved words in Oracle PL/SQL

The following words are reserved words in Oracle PL/SQL (in 10g). Bold words indicate they're also reserved in SQL.

all
alter
and
any
array
as
asc
at
authid
avg
begin
between
binary_integer
body
boolean
bulk
by
char
char_base
check
close
cluster
coalesce
collect
comment
commit
compress
connect
constant
create
current
currval
cursor
date
day
decimal
declare
default
delete
desc
distinct
do
drop
else
elsif
end
exception
exclusive
execute
exists
exit
extends
extract
false
fetch
float
for
forall
from
function
goto
group
having
heap
hour
if
immediate
in
index
indicator
insert
integer
interface
intersect
interval
into
is
isolation
java
level
like
limited
lock
long
loop
max
min
minus
minute
mlslabel
mod
mode
month
natural
naturaln
new
nextval
nocopy
not
nowait
null
nullif
number
number_base
ocirowid
of
on
opaque
open
operator
option
or
order
organization
others
out
package
partition
pctfree
pls_integer
positive
positiven
pragma
prior
private
procedure
public
raise
range
raw
real
record
ref
release
return
reverse
rollback
row
rowid
rownum
rowtype
savepoint
second
select
seperate
set
share
smallint
space
sql
sqlcode
sqlerrm
start
stddev
subtype
successful
sum
synonym
sysdate
table
then
time
timestamp
timezone_abbr
timezone_hour
timezone_minute
timezone_region
to
trigger
true
type
ui
union
unique
update
use
user
validate
values
varchar
varchar2
variance
view
when
whenever
where
while
with
work
write
year
zone


	René Nyffenegger's collection of things on the web
	René Nyffenegger on Oracle - Most wanted - Feedback - Follow @renenyffenegger

		Reserved words in Oracle PL/SQL
		The following words are reserved words in Oracle PL/SQL (in 10g). Bold words indicate they're also reserved in SQL. all alter and any array as asc at authid avg begin between binary_integer body boolean bulk by char char_base check close cluster coalesce collect comment commit compress connect constant create current currval cursor date day decimal declare default delete desc distinct do drop else elsif end exception exclusive execute exists exit extends extract false fetch float for forall from function goto group having heap hour if immediate in index indicator insert integer interface intersect interval into is isolation java level like limited lock long loop max min minus minute mlslabel mod mode month natural naturaln new nextval nocopy not nowait null nullif number number_base ocirowid of on opaque open operator option or order organization others out package partition pctfree pls_integer positive positiven pragma prior private procedure public raise range raw real record ref release return reverse rollback row rowid rownum rowtype savepoint second select seperate set share smallint space sql sqlcode sqlerrm start stddev subtype successful sum synonym sysdate table then time timestamp timezone_abbr timezone_hour timezone_minute timezone_region to trigger true type ui union unique update use user validate values varchar varchar2 variance view when whenever where while with work write year zone Links See also v$reserved_words and reserved words in SQL.

Reserved words in Oracle PL/SQL

Links