C
Oracle Reserved Words and Keywords
This appendix lists Oracle reserved words and keywords.
Table C-1, "Reserved Words" lists Oracle reserved words. Words followed by an asterisk (*) are also ANSI reserved words.
Note:
In addition to the following reserved words, Oracle uses system-generated names beginning with "SYS_" for implicitly generated schema objects and subobjects. Oracle discourages you from using this prefix in the names you explicitly provide to your schema objects and subobjects to avoid possible conflict in name resolution.
|
Table C-1 Reserved Words
|
ACCESS
|
AUDIT
|
COMPRESS
|
DESC*
|
|
ADD*
|
BETWEEN*
|
CONNECT*
|
DISTINCT*
|
|
ALL*
|
BY*
|
CREATE*
|
DROP*
|
|
ALTER*
|
CHAR*
|
CURRENT*
|
ELSE*
|
|
AND*
|
CHECK*
|
DATE*
|
EXCLUSIVE
|
|
ANY*
|
CLUSTER
|
DECIMAL*
|
EXISTS
|
|
AS*
|
COLUMN
|
DEFAULT*
|
FILE
|
|
ASC*
|
COMMENT
|
DELETE*
|
FLOAT*
|
|
|
|
|
|
|
FOR*
|
LONG
|
PCTFREE
|
SUCCESSFUL
|
|
FROM*
|
MAXEXTENTS
|
PRIOR*
|
SYNONYM
|
|
GRANT*
|
MINUS
|
PRIVILEGES*
|
SYSDATE
|
|
GROUP*
|
MODE
|
PUBLIC*
|
TABLE*
|
|
HAVING*
|
MODIFY
|
RAW
|
THEN*
|
|
IDENTIFIED
|
NETWORK
|
RENAME
|
TO*
|
|
IMMEDIATE*
|
NOAUDIT
|
RESOURCE
|
TRIGGER
|
|
IN*
|
NOCOMPRESS
|
REVOKE*
|
UID
|
|
INCREMENT
|
NOT*
|
ROW
|
UNION*
|
|
INDEX
|
NOWAIT
|
ROWID
|
UNIQUE*
|
|
INITIAL
|
NULL*
|
ROWNUM
|
UPDATE*
|
|
INSERT*
|
NUMBER
|
ROWS*
|
USER*
|
|
INTEGER*
|
OF*
|
SELECT*
|
VALIDATE
|
|
INTERSECT*
|
OFFLINE
|
SESSION*
|
VALUES*
|
|
INTO*
|
ON*
|
SET*
|
VARCHAR*
|
|
IS*
|
ONLINE
|
SHARE
|
VARCHAR2
|
|
LEVEL*
|
OPTION*
|
SIZE*
|
VIEW*
|
|
LIKE*
|
OR*
|
SMALLINT*
|
WHENEVER*
|
|
LOCK
|
ORDER*
|
START
|
WHERE
|
|
|
|
|
WITH*
|
Table C-2, " Keywords" lists Oracle keywords. Keywords marked with asterisks (*) are also ANSI reserved words. For maximum portability to other implementations of SQL, do not use these words as schema object names.
|
ACCOUNT
|
CACHE_INSTANCES
|
CONSTRAINT*
|
DEGREE
|
|
ACTIVATE
|
CANCEL
|
CONSTRAINTS*
|
DEREF
|
|
ADMIN
|
CASCADE*
|
CONTENTS
|
DIRECTORY
|
|
AFTER
|
CAST
|
CONTINUE*
|
DISABLE
|
|
ALLOCATE*
|
CFILE
|
CONTROLFILE
|
DISCONNECT
|
|
ALL_ROWS
|
CHAINED
|
CONVERT*
|
DISMOUNT
|
|
ANALYZE
|
CHANGE
|
COST
|
DISTRIBUTED
|
|
ARCHIVE
|
CHARACTER*
|
COUNT*
|
DML
|
|
ARCHIVELOG
|
CHAR_CS
|
CPU_PER_CALL
|
DOUBLE*
|
|
ARRAY
|
CHECKPOINT
|
CPU_PER_SESSION
|
DUMP
|
|
AT*
|
CHOOSE
|
CURRENT_SCHEMA
|
|
|
AUTHENTICATED
|
CHUNK
|
CURRENT_USER*
|
EACH
|
|
AUTHORIZATION
|
CLEAR
|
CURSOR*
|
ENABLE
|
|
AUTOEXTEND
|
CLOB
|
CYCLE
|
END*
|
|
AUTOMATIC
|
CLONE
|
|
ENFORCE
|
|
|
CLOSE*
|
DANGLING
|
ENTRY
|
|
BACKUP
|
CLOSED_CACHED_OPEN_
CURSORS
|
DATABASE
|
ESCAPE*
|
|
BECOME
|
COALESCE*
|
DATAFILE
|
ESTIMATE
|
|
BEFORE
|
COLUMNS
|
DATAFILES
|
EVENTS
|
|
BEGIN*
|
COMMIT*
|
DATAOBJNO
|
EXEMPT*
|
|
BFILE
|
COMMITTED
|
DBA
|
EXCEPTIONS
|
|
BITMAP
|
COMPATIBILITY
|
DEALLOCATE*
|
EXCHANGE
|
|
BLOB
|
COMPILE
|
DEBUG
|
EXCLUDING
|
|
BLOCK
|
COMPLETE
|
DEC*
|
EXECUTE*
|
|
BODY
|
COMPOSITE_LIMIT
|
DECLARE*
|
EXPIRE
|
|
|
COMPUTE
|
DEFERRABLE
|
EXPLAIN
|
|
CACHE
|
CONNECT_TIME
|
DEFERRED
|
EXTENT
|
|
|
|
|
|
|
EXTENTS
|
INDEXES
|
MANAGE
|
NLS_CALENDAR
|
|
EXTERNALLY
|
INDICATOR*
|
MASTER
|
NLS_CHARACTERSET
|
|
|
IND_PARTITION
|
MAX*
|
NLS_ISO_CURRENCY
|
|
FAILED_LOGIN_ATTEMPTS
|
INITIALLY
|
MAXARCHLOGS
|
NLS_LANGUAGE
|
|
FALSE
|
INITRANS
|
MAXDATAFILES
|
NLS_NUMERIC_
CHARACTERS
|
|
FAST
|
INSTANCE
|
MAXINSTANCES
|
NLS_SORT
|
|
FIRST_ROWS
|
INSTANCES
|
MAXLOGFILES
|
NOS_SPECIAL_CHARS
|
|
FLAGGER
|
INSTEAD
|
MAXLOGHISTORY
|
NLS_TERRITORY
|
|
FLUSH
|
INT*
|
MAXLOGMEMBERS
|
NOARCHIVELOG
|
|
FORCE
|
INTERMEDIATE
|
MAXSIZE
|
NOCACHE
|
|
FOREIGN*
|
ISOLATION*
|
MAXTRANS
|
NOCYCLE
|
|
FREELIST
|
ISOLATION_LEVEL
|
MAXVALUE
|
NOFORCE
|
|
FREELISTS
|
|
MEMBER
|
NOLOGGING
|
|
FULL
|
KEEP
|
MIN*
|
NOMAXVALUE
|
|
FUNCTION
|
KEY*
|
MINEXTENTS
|
NOMINVALUE
|
|
|
KILL
|
MINIMUM
|
NONE
|
|
GLOBAL*
|
|
MINVALUE
|
NOORDER
|
|
GLOBALLY
|
LAYER
|
MOUNT
|
NOOVERIDE
|
|
GLOBAL_NAME
|
LESS
|
MOVE
|
NOPARALLEL
|
|
GROUPS
|
LIBRARY
|
MTS_DISPATCHERS
|
NORESETLOGS
|
|
HASH
|
LIMIT
|
MULTISET
|
NOREVERSE
|
|
HASHKEYS
|
LINK
|
|
NORMAL
|
|
HEADER
|
LIST
|
NATIONAL*
|
NOSORT
|
|
INSTANCE
|
LOB
|
NCHAR*
|
NOTHING
|
|
HEAP
|
LOCAL*
|
NCHAR_CS
|
NUMERIC*
|
|
|
LOG
|
NCLOB
|
NVARCHAR2
|
|
IDLE_TIME
|
LOGFILE
|
NEEDED
|
OBJECT
|
|
IF
|
LOGGING
|
NESTED
|
OBJNO
|
|
INCLUDING
|
LOGICAL_READS_PER_CALL
|
NEW
|
OBJNO_REUSE
|
|
INDEXED
|
LOGICAL_READS_PER_
SESSION
|
NEXT*
|
OFF
|
|
OID
|
PLSQL_DEBUG
|
RESIZE
|
SHARED_POOL
|
|
OIDINDEX
|
POST_TRANSACTION
|
RESTRICTED
|
SHRINK
|
|
OLD
|
PRECISION*
|
RETURN
|
SKIM_UNUSABLE_INDEXES
|
|
ONLY*
|
PRESERVE*
|
RETURNING
|
SNAPSHOT
|
|
OPCODE
|
PRIMARY*
|
REUSE
|
SOME*
|
|
OPEN*
|
PRIVATE
|
REVERSE
|
SORT
|
|
OPTIMAL
|
PRIVATE_SGA
|
ROLE
|
SPECIFICATION
|
|
OPTIMIZER_GOAL
|
PRIVILEGE
|
ROLES
|
SPLIT
|
|
ORGANIZATION
|
PROCEDURE*
|
ROLLBACK*
|
SQLCODE*
|
|
OVERFLOW
|
PROFILE
|
ROWLABEL
|
SQLERROR*
|
|
OWN
|
PURGE
|
RULE
|
SQL_TRACE
|
|
|
|
|
STANDBY
|
|
PACKAGE
|
QUEUE
|
SAMPLE
|
STATEMENT_ID
|
|
PARALLEL
|
QUOTA
|
SAVEPOINT
|
STATISTICS
|
|
PARTITION
|
|
SCAN_INSTANCES
|
STOP
|
|
PASSWORD
|
RANGE
|
SCHEMA*
|
STORAGE
|
|
PASSWORD_GRACE_TIME
|
RBA
|
SCN
|
STORE
|
|
PASSWORD_LIFE_TIME
|
READ*
|
SCOPE
|
STRUCTURE
|
|
PASSWORD_LOCK_TIME
|
REAL*
|
SD_ALL
|
SUM*
|
|
PASSWORD_REUSE_MAX
|
REBUILD
|
SD_INHIBIT
|
SWITCH
|
|
PASSWORD_REUSE_TIME
|
RECOVER
|
SD_SHOW
|
SYSDBA
|
|
PASSWORD_VERIFY_
FUNCTION
|
RECOVERABLE
|
SEGMENT
|
SYSOPER
|
|
PCTINCREASE
|
RECOVERY
|
SEG_BLOCK
|
SYSTEM
|
|
PCTTHRESHOLD
|
REF
|
SEG_FILE
|
|
|
PCTUSED
|
REFERENCES*
|
SEQUENCE
|
TABLES
|
|
PCTVERSION
|
REFERENCING
|
SERIALIZABLE
|
TABLESPACE
|
|
PERCENT
|
REFRESH
|
SESSIONS_PER_USER
|
TABLESPACE_NO
|
|
PERMANENT
|
REPLACE
|
SESSION_CACHED_
CURSORS
|
TABNO
|
|
PLAN
|
RESET
|
SHARED
|
TEMPORARY*
|
|
|
RESETLOGS
|
|
|
|
THAN
|
TRUE
|
UNLOCK
|
VALIDATION
|
|
THE
|
TRUNCATE
|
UNRECOVERABLE
|
VALUE
|
|
THREAD
|
TX
|
UNTIL*
|
VARRAY
|
|
TIME
|
TYPE
|
UNUSABLE
|
VARYING*
|
|
TIMESTAMP
|
|
UNUSED
|
WHEN
|
|
TOPLEVEL
|
UBA
|
UPDATABLE
|
WITHOUT
|
|
TRACE
|
UNARCHIVED
|
USAGE*
|
WORK*
|
|
TRACING
|
UNDER
|
USE
|
WRITE*
|
|
TRANSACTION*
|
UNDO
|
USING*
|
|
|
TRANSITIONAL
|
UNLIMITED
|
|
XID
|
|
TRIGGERS
|
|
|
|
|
|
|
|
|
