List of Oracle Reserved Words
|
Oracle Reserved Words and Keywords
|
||
|
ACCESS
|
ACCOUNT
|
ACTIVATE
|
|
ADD
|
ADMIN
|
ADVISE
|
|
AFTER
|
ALL
|
ALL_ROWS
|
|
ALLOCATE
|
ALTER
|
ANALYZE
|
|
AND
|
ANY
|
ARCHIVE
|
|
ARCHIVELOG
|
ARRAY
|
AS
|
|
ASC
|
AT
|
AUDIT
|
|
AUTHENTICATED
|
AUTHORIZATION
|
AUTOEXTEND
|
|
AUTOMATIC
|
BACKUP
|
BECOME
|
|
BEFORE
|
BEGIN
|
BETWEEN
|
|
BFILE
|
BITMAP
|
BLOB
|
|
BLOCK
|
BODY
|
BY
|
|
CACHE
|
CACHE_INSTANCES
|
CANCEL
|
|
CASCADE
|
CAST
|
CFILE
|
|
CHAINED
|
CHANGE
|
CHAR
|
|
CHAR_CS
|
CHARACTER
|
CHECK
|
|
CHECKPOINT
|
CHOOSE
|
CHUNK
|
|
CLEAR
|
CLOB
|
CLONE
|
|
CLOSE
|
CLOSE_CACHED_OPEN_CURSORS
|
CLUSTER
|
|
COALESCE
|
COLUMN
|
COLUMNS
|
|
COMMENT
|
COMMIT
|
COMMITTED
|
|
COMPATIBILITY
|
COMPILE
|
COMPLETE
|
|
COMPOSITE_LIMIT
|
COMPRESS
|
COMPUTE
|
|
CONNECT
|
CONNECT_TIME
|
CONSTRAINT
|
|
CONSTRAINTS
|
CONTENTS
|
CONTINUE
|
|
CONTROLFILE
|
CONVERT
|
COST
|
|
CPU_PER_CALL
|
CPU_PER_SESSION
|
CREATE
|
|
CURRENT
|
CURRENT_SCHEMA
|
CURREN_USER
|
|
CURSOR
|
CYCLE
|
|
|
DANGLING
|
DATABASE
|
DATAFILE
|
|
DATAFILES
|
DATAOBJNO
|
DATE
|
|
DBA
|
DBHIGH
|
DBLOW
|
|
DBMAC
|
DEALLOCATE
|
DEBUG
|
|
DEC
|
DECIMAL
|
DECLARE
|
|
DEFAULT
|
DEFERRABLE
|
DEFERRED
|
|
DEGREE
|
DELETE
|
DEREF
|
|
DESC
|
DIRECTORY
|
DISABLE
|
|
DISCONNECT
|
DISMOUNT
|
DISTINCT
|
|
DISTRIBUTED
|
DML
|
DOUBLE
|
|
DROP
|
DUMP
|
EACH
|
|
ELSE
|
ENABLE
|
END
|
|
ENFORCE
|
ENTRY
|
ESCAPE
|
|
EXCEPT
|
EXCEPTIONS
|
EXCHANGE
|
|
EXCLUDING
|
EXCLUSIVE
|
EXECUTE
|
|
EXISTS
|
EXPIRE
|
EXPLAIN
|
|
EXTENT
|
EXTENTS
|
EXTERNALLY
|
|
FAILED_LOGIN_ATTEMPTS
|
FALSE
|
FAST
|
|
FILE
|
FIRST_ROWS
|
FLAGGER
|
|
FLOAT
|
FLOB
|
FLUSH
|
|
FOR
|
FORCE
|
FOREIGN
|
|
FREELIST
|
FREELISTS
|
FROM
|
|
FULL
|
FUNCTION
|
GLOBAL
|
|
GLOBALLY
|
GLOBAL_NAME
|
GRANT
|
|
GROUP
|
GROUPS
|
HASH
|
|
HASHKEYS
|
HAVING
|
HEADER
|
|
HEAP
|
IDENTIFIED
|
IDGENERATORS
|
|
IDLE_TIME
|
IF
|
IMMEDIATE
|
|
IN
|
INCLUDING
|
INCREMENT
|
|
INDEX
|
INDEXED
|
INDEXES
|
|
INDICATOR
|
IND_PARTITION
|
INITIAL
|
|
INITIALLY
|
INITRANS
|
INSERT
|
|
INSTANCE
|
INSTANCES
|
INSTEAD
|
|
INT
|
INTEGER
|
INTERMEDIATE
|
|
INTERSECT
|
INTO
|
IS
|
|
ISOLATION
|
ISOLATION_LEVEL
|
KEEP
|
|
KEY
|
KILL
|
LABEL
|
|
LAYER
|
LESS
|
LEVEL
|
|
LIBRARY
|
LIKE
|
LIMIT
|
|
LINK
|
LIST
|
LOB
|
|
LOCAL
|
LOCK
|
LOCKED
|
|
LOG
|
LOGFILE
|
LOGGING
|
|
LOGICAL_READS_PER_CALL
|
LOGICAL_READS_PER_SESSION
|
LONG
|
|
MANAGE
|
MASTER
|
MAX
|
|
MAXARCHLOGS
|
MAXDATAFILES
|
MAXEXTENTS
|
|
MAXINSTANCES
|
MAXLOGFILES
|
MAXLOGHISTORY
|
|
MAXLOGMEMBERS
|
MAXSIZE
|
MAXTRANS
|
|
MAXVALUE
|
MIN
|
MEMBER
|
|
MINIMUM
|
MINEXTENTS
|
MINUS
|
|
MINVALUE
|
MLSLABEL
|
MLS_LABEL_FORMAT
|
|
MODE
|
MODIFY
|
MOUNT
|
|
MOVE
|
MTS_DISPATCHERS
|
MULTISET
|
|
NATIONAL
|
NCHAR
|
NCHAR_CS
|
|
NCLOB
|
NEEDED
|
NESTED
|
|
NETWORK
|
NEW
|
NEXT
|
|
NOARCHIVELOG
|
NOAUDIT
|
NOCACHE
|
|
NOCOMPRESS
|
NOCYCLE
|
NOFORCE
|
|
NOLOGGING
|
NOMAXVALUE
|
NOMINVALUE
|
|
NONE
|
NOORDER
|
NOOVERRIDE
|
|
NOPARALLEL
|
NOPARALLEL
|
NOREVERSE
|
|
NORMAL
|
NOSORT
|
NOT
|
|
NOTHING
|
NOWAIT
|
NULL
|
|
NUMBER
|
NUMERIC
|
NVARCHAR2
|
|
OBJECT
|
OBJNO
|
OBJNO_REUSE
|
|
OF
|
OFF
|
OFFLINE
|
|
OID
|
OIDINDEX
|
OLD
|
|
ON
|
ONLINE
|
ONLY
|
|
OPCODE
|
OPEN
|
OPTIMAL
|
|
OPTIMIZER_GOAL
|
OPTION
|
OR
|
|
ORDER
|
ORGANIZATION
|
OSLABEL
|
|
OVERFLOW
|
OWN
|
PACKAGE
|
|
PARALLEL
|
PARTITION
|
PASSWORD
|
|
PASSWORD_GRACE_TIME
|
PASSWORD_LIFE_TIME
|
PASSWORD_LOCK_TIME
|
|
PASSWORD_REUSE_MAX
|
PASSWORD_REUSE_TIME
|
PASSWORD_VERIFY_FUNCTION
|
|
PCTFREE
|
PCTINCREASE
|
PCTTHRESHOLD
|
|
PCTUSED
|
PCTVERSION
|
PERCENT
|
|
PERMANENT
|
PLAN
|
PLSQL_DEBUG
|
|
POST_TRANSACTION
|
PRECISION
|
PRESERVE
|
|
PRIMARY
|
PRIOR
|
PRIVATE
|
|
PRIVATE_SGA
|
PRIVILEGE
|
PRIVILEGES
|
|
PROCEDURE
|
PROFILE
|
PUBLIC
|
|
PURGE
|
QUEUE
|
QUOTA
|
|
RANGE
|
RAW
|
RBA
|
|
READ
|
READUP
|
REAL
|
|
REBUILD
|
RECOVER
|
RECOVERABLE
|
|
RECOVERY
|
REF
|
REFERENCES
|
|
REFERENCING
|
REFRESH
|
RENAME
|
|
REPLACE
|
RESET
|
RESETLOGS
|
|
RESIZE
|
RESOURCE
|
RESTRICTED
|
|
RETURN
|
RETURNING
|
REUSE
|
|
REVERSE
|
REVOKE
|
ROLE
|
|
ROLES
|
ROLLBACK
|
ROW
|
|
ROWID
|
ROWNUM
|
ROWS
|
|
RULE
|
SAMPLE
|
SAVEPOINT
|
|
SB4
|
SCAN_INSTANCES
|
SCHEMA
|
|
SCN
|
SCOPE
|
SD_ALL
|
|
SD_INHIBIT
|
SD_SHOW
|
SEGMENT
|
|
SEG_BLOCK
|
SEG_FILE
|
SELECT
|
|
SEQUENCE
|
SERIALIZABLE
|
SESSION
|
|
SESSION_CACHED_CURSORS
|
SESSIONS_PER_USER
|
SET
|
|
SHARE
|
SHARED
|
SHARED_POOL
|
|
SHRINK
|
SIZE
|
SKIP
|
|
SKIP_UNUSABLE_INDEXES
|
SMALLINT
|
SNAPSHOT
|
|
SOME
|
SORT
|
SPECIFICATION
|
|
SPLIT
|
SQL_TRACE
|
STANDBY
|
|
START
|
STATEMENT_ID
|
STATISTICS
|
|
STOP
|
STORAGE
|
STORE
|
|
STRUCTURE
|
SUCCESSFUL
|
SWITCH
|
|
SYS_OP_ENFORCE_NOT_NULL$
|
SYS_OP_NTCIMG$
|
SYNONYM
|
|
SYSDATE
|
SYSDBA
|
SYSOPER
|
|
SYSTEM
|
TABLE
|
TABLES
|
|
TABLESPACE
|
TABLESPACE_NO
|
TABNO
|
|
TEMPORARY
|
THAN
|
THE
|
|
THEN
|
THREAD
|
TIMESTAMP
|
|
TIME
|
TO
|
TOPLEVEL
|
|
TRACE
|
TRACING
|
TRANSACTION
|
|
TRANSITIONAL
|
TRIGGER
|
TRIGGERS
|
|
TRUE
|
TRUNCATE
|
TX
|
|
TYPE
|
UB2
|
UBA
|
|
UID
|
UNARCHIVED
|
UNDO
|
|
UNION
|
UNIQUE
|
UNLIMITED
|
|
UNLOCK
|
UNRECOVERABLE
|
UNTIL
|
|
UNUSABLE
|
UNUSED
|
UPDATABLE
|
|
UPDATE
|
USAGE
|
USE
|
|
USER
|
USING
|
VALIDATE
|
|
VALIDATION
|
VALUE
|
VALUES
|
|
VARCHAR
|
VARCHAR2
|
VARYING
|
|
VIEW
|
WHEN
|
WHENEVER
|
|
WHERE
|
WITH
|
WITHOUT
|
|
WORK
|
WRITE
|
WRITEDOWN
|
|
WRITEUP
|
XID
|
YEAR
|
|
ZONE
|
|
|
