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

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