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

Reserved words in Oracle SQL

The following words are reserved words in Oracle SQL (in 10g). Bold words indicate they're also reserved in the ANSI standard.
  • access
  • add
  • all
  • alter
  • and
  • any
  • as
  • asc
  • audit
  • between
  • by
  • char
  • check
  • cluster
  • column
  • comment
  • compress
  • connect
  • create
  • current
  • date
  • decimal
  • default
  • delete
  • desc
  • distinct
  • drop
  • else
  • exclusive
  • exists
  • file
  • float
  • for
  • from
  • grant
  • group
  • having
  • identified
  • immediate
  • in
  • increment
  • index
  • initial
  • insert
  • integer
  • intersect
  • into
  • is
  • level
  • like
  • lock
  • long
  • maxextents
  • minus
  • mlslabel
  • mode
  • modify
  • noaudit
  • nocompress
  • not
  • nowait
  • null
  • number
  • of
  • offline
  • on
  • online
  • option
  • or
  • order
  • pctfree
  • prior
  • privileges
  • public
  • raw
  • rename
  • resource
  • revoke
  • row
  • rowid
  • rownum
  • rows
  • select
  • session
  • set
  • share
  • size
  • smallint
  • start
  • successful
  • synonym
  • sysdate
  • table
  • then
  • to
  • trigger
  • uid
  • union
  • unique
  • update
  • user
  • validate
  • values
  • varchar
  • varchar2
  • view
  • whenever
  • where
  • with

SQL_ prefix

When Oracle generates a name for an Objects, it usually prefixes it with SYS_. For example, if I don't name a check constraint, Oracle will choose a name that starts with SYS_:
create table prefix_ex (
  a number check (a > 10)
);

select constraint_name from user_constraints
 where table_name = 'PREFIX_EX';
CONSTRAINT_NAME
------------------------------
SYS_C005096

Links