Oracle Reserved Words, Keywords and Namespaces

Oracle Reserved Words, Keywords and Namespaces
Oracle Reserved Words

The following words are reserved by Oracle. That is, they have a special meaning to Oracle and so cannot be redefined. For this reason, you cannot use them to name database objects such as columns, tables, or indexes.

Oracle Reserved Words
ACCESSELSEMODIFYSTART
ADDEXCLUSIVENOAUDITSELECT
ALLEXISTSNOCOMPRESSSESSION
ALTERFILENOTSET
ANDFLOATNOTFOUNDSHARE
ANYFORNOWAITSIZE
ARRAYLENFROMNULLSMALLINT
ASGRANTNUMBERSQLBUF
ASCGROUPOFSUCCESSFUL
AUDITHAVINGOFFLINESYNONYM
BETWEENIDENTIFIEDONSYSDATE
BYIMMEDIATEONLINETABLE
CHARINOPTIONTHEN
CHECKINCREMENTORTO
CLUSTERINDEXORDERTRIGGER
COLUMNINITIALPCTFREEUID
COMMENTINSERTPRIORUNION
COMPRESSINTEGERPRIVILEGESUNIQUE
CONNECTINTERSECTPUBLICUPDATE
CREATEINTORAWUSER
CURRENTISRENAMEVALIDATE
DATELEVELRESOURCEVALUES
DECIMALLIKEREVOKEVARCHAR
DEFAULTLOCKROWVARCHAR2
DELETELONGROWIDVIEW
DESCMAXEXTENTSROWLABELWHENEVER
DISTINCTMINUSROWNUMWHERE
DROPMODEROWSWITH

Oracle Keywords

The following words also have a special meaning to Oracle but are not reserved words and so can be redefined. However, some might eventually become reserved words.
Oracle Keywords
ADMINCURSORFOUNDMOUNT
AFTERCYCLEFUNCTIONNEXT
ALLOCATEDATABASEGONEW
ANALYZEDATAFILEGOTONOARCHIVELOG
ARCHIVEDBAGROUPSNOCACHE
ARCHIVELOGDECINCLUDINGNOCYCLE
AUTHORIZATIONDECLAREINDICATORNOMAXVALUE
AVGDISABLEINITRANSNOMINVALUE
BACKUPDISMOUNTINSTANCENONE
BEGINDOUBLEINTNOORDER
BECOMEDUMPKEYNORESETLOGS
BEFOREEACHLANGUAGENORMAL
BLOCKENABLELAYERNOSORT
BODYENDLINKNUMERIC
CACHEESCAPELISTSOFF
CANCELEVENTSLOGFILEOLD
CASCADEEXCEPTMANAGEONLY
CHANGEEXCEPTIONSMANUALOPEN
CHARACTEREXECMAXOPTIMAL
CHECKPOINTEXPLAINMAXDATAFILESOWN
CLOSEEXECUTEMAXINSTANCESPACKAGE
COBOLEXTENTMAXLOGFILESPARALLEL
COMMITEXTERNALLYMAXLOGHISTORYPCTINCREASE
COMPILEFETCHMAXLOGMEMBERSPCTUSED
CONSTRAINTFLUSHMAXTRANSPLAN
CONSTRAINTSFREELISTMAXVALUEPLI
CONTENTSFREELISTSMINPRECISION
CONTINUEFORCEMINEXTENTSPRIMARY
CONTROLFILEFOREIGNMINVALUEPRIVATE
COUNTFORTRANMODULEPROCEDURE
PROFILESAVEPOINTSQLSTATETRACING
QUOTASCHEMASTATEMENT_IDTRANSACTION
READSCNSTATISTICSTRIGGERS
REALSECTIONSTOPTRUNCATE
RECOVERSEGMENTSTORAGEUNDER
REFERENCESSEQUENCESUMUNLIMITED
REFERENCINGSHAREDSWITCHUNTIL
RESETLOGSSNAPSHOTSYSTEMUSE
RESTRICTEDSOMETABLESUSING
REUSESORTTABLESPACEWHEN
ROLESQLTEMPORARYWRITE
ROLESSQLCODETHREADWORK
ROLLBACKSQLERRORTIME

PL/SQL Reserved Words

The following PL/SQL keywords may require special treatment when used in embedded SQL statements.
PL/SQL Reserved Words
ABORTBETWEENCRASHDIGITS
ACCEPTBINARY_INTEGERCREATEDISPOSE
ACCESSBODYCURRENTDISTINCT
ADDBOOLEANCURRVALDO
ALLBYCURSORDROP
ALTERCASEDATABASEELSE
ANDCHARDATA_BASEELSIF
ANYCHAR_BASEDATEEND
ARRAYCHECKDBAENTRY
ARRAYLENCLOSEDEBUGOFFEXCEPTION
ASCLUSTERDEBUGONEXCEPTION_INIT
ASCCLUSTERSDECLAREEXISTS
ASSERTCOLAUTHDECIMALEXIT
ASSIGNCOLUMNSDEFAULTFALSE
ATCOMMITDEFINITIONFETCH
AUTHORIZATIONCOMPRESSDELAYFLOAT
AVGCONNECTDELETEFOR
BASE_TABLECONSTANTDELTAFORM
BEGINCOUNTDESCFROM
FUNCTIONNEWRELEASESUM
GENERICNEXTVALREMRTABAUTH
GOTONOCOMPRESSRENAMETABLE
GRANTNOTRESOURCETABLES
GROUPNULLRETURNTASK
HAVINGNUMBERREVERSETERMINATE
IDENTIFIEDNUMBER_BASEREVOKETHEN
IFOFROLLBACKTO
INONROWIDTRUE
INDEXOPENROWLABELTYPE
INDEXESOPTIONROWNUMUNION
INDICATORORROWTYPEUNIQUE
INSERTORDERRUNUPDATE
INTEGEROTHERSSAVEPOINTUSE
INTERSECTOUTSCHEMAVALUES
INTOPACKAGESELECTVARCHAR
ISPARTITIONSEPARATEVARCHAR2
LEVELPCTFREESETVARIANCE
LIKEPOSITIVESIZEVIEW
LIMITEDPRAGMASMALLINTVIEWS
LOOPPRIORSPACEWHEN
MAXPRIVATESQLWHERE
MINPROCEDURESQLCODEWHILE
MINUSPUBLICSQLERRMWITH
MLSLABELRAISESTARTWORK
MODRANGESTATEMENTXOR
MODEREALSTDDEV
NATURALRECORDSUBTYPE

Oracle Reserved Namespaces

Table 1 contains a list of namespaces that are reserved by Oracle. The initial characters of function names in Oracle libraries are restricted to the character strings in this list. Because of potential name conflicts, use function names that do not begin with these characters.
For example, the SQL*Net Transparent Network Service functions all begin with the characters "NS," so you need to avoid naming functions that begin with "NS."
Table B-1 Oracle Reserved Namespaces
NamespaceLibrary
O
OCI functions
S
function names from SQLLIB and system-dependent libraries
XA
external functions for XA applications only
GEN KP L NA NC ND NL NM NR NS NT NZ TTC UPI
Internal functions
*/