Oracle Keyword Reserved Words

The Oracle SQL language contains keywords that have special meaning to Oracle, but are not reserved. Although these words are not reserved, they should be avoided to eliminate confusion in your SQL.

A
ADMIN	AFTER	ALLOCATE
ANALYZE	ARCHIVE	ARCHIVELOG
AUTHORIZATION	AVG
B
BACKUP	BECOME	BEFORE
BEGIN	BLOCK	BODY
C
CACHE	CANCEL	CASCADE
CHANGE	CHARACTER	CHECKPOINT
CLOSE	COBOL	COMMIT
COMPILE	CONSTRAINT	CONSTRAINTS
CONTENTS	CONTINUE	CONTROLFILE
COUNT	CURSOR	CYCLE
D
DATABASE	DATAFILE	DBA
DEC	DECLARE	DISABLE
DISMOUNT	DOUBLE	DUMP
E
EACH	ENABLE	END
ESCAPE	EVENTS	EXCEPT
EXCEPTIONS	EXEC	EXECUTE
EXPLAIN	EXTENT	EXTERNALLY
F
FETCH	FLUSH	FORCE
FOREIGN	FORTRAN	FOUND
FREELIST	FREELISTS	FUNCTION
G
GO	GOTO	GROUPS
I
INCLUDING	INDICATOR	NITRANS
INSTANCE	INT
K
KEY
L
LANGUAGE	LAYER	LINK
LISTS	LOGFILE
M
MANAGE	MANUAL	MAX
MAXDATAFILES	MAXINSTANCES	MAXLOGFILES
MAXLOGHISTORY	MAXLOGMEMBERS	MAXTRANS
MAXVALUE	MIN	MINEXTENTS
MINVALUE	MODULE	MOUNT
N
NEW	NEXT	NOARCHIVELOG
NOCACHE	NOCYCLE	NOMAXVALUE
NOMINVALUE	NONE	NOORDER
NORESETLOGS	NORMAL	NOSORT
NUMERIC
O
OFF	OLD	ONLY
OPEN	OPTIMAL	OWN
P
PACKAGE	PARALLEL	PASCAL
PCTINCREASE	PCTUSED	PLAN
PLI	PRECISION	PRIMARY
PRIVATE	PROCEDURE	PROFILE
Q
QUOTA
R
READ	REAL	RECOVER
REFERENCES	REFERENCING	RESETLOGS
RESTRICTED	REUSE	ROLE
ROLES	ROLLBACK
S
SAVEPOINT	SCHEMA	SCN
SECTION	SEGMENT	SEQUENCE
SHARED	SNAPSHOT	SOME
SORT	SQLCODE	SQLERROR
STATEMENT_ID	STATISTICS	STOP
STORAGE	SUM	SWITCH
SYSTEM
T
TABLES	TABLESPACE	TEMPORARY
THREAD	TIME	TRACING
TRANSACTION	TRIGGERS	TRUNCATE
U
UNDER	UNLIMITED	UNTIL
USE	USING
W
WHEN	WORK