Oracle Reserved Words

1          Appendix A – Oracle Reserved Words

1.1        Oracle 8.1.7 Reserved Words

This appendix lists Oracle reserved words.  Oracle changes reserved words with each version of its product.  For a complete listing of reserved words, developers must use https://metalink.oracle.com.  Words followed by an asterisk (*) are also ANSI reserved words.  Developers must only use these words in Oracle related context.

Note: In addition to the following reserved words, Oracle uses system-generated names beginning with "SYS_" for implicitly generated schema objects and sub-objects.  Oracle discourages developers from using this prefix in the names explicitly given to custom schema objects and sub-objects to avoid possible conflict in name resolution.

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

ROWS*

ROWID

ROWNUM

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*

1.2        PL/SQL 8.1.7 Reserved Words

PL/SQL reserves the words listed in this appendix.  That is, they have a special syntactic meaning to PL/SQL.  Therefore, developers should not use them to name program objects such as constants, variables, or cursors.  SQL also reserves some of these words (marked by an asterisk).  Therefore, developers should not use them to name schema objects such as columns, tables, or indexes.  Oracle changes reserved words with each version of its product.  For a complete listing of reserved words, developers must use https://metalink.oracle.com. 

ALL*

ALTER*

AND*

ANY*

ARRAY

AS*

ASC*

AT

AUTHID

AVG

BEGIN

BETWEEN*

BINARY_INTEGER

BODY

BOOLEAN

BULK

BY*

CHAR*

CHAR_BASE

CHECK*

CLOSE

CLUSTER*

COLLECT

COMMENT*

COMMIT

COMPRESS*

CONNECT*

CONSTANT

CREATE*

CURRENT*

CURRVAL

CURSOR

DATE*

DAY

DECIMAL*

DECLARE

DEFAULT*

DELETE*

DESC*

DISTINCT*

DO

DROP*

ELSE*

ELSIF

END

EXCEPTION

EXCLUSIVE*

EXECUTE

EXISTS*

EXIT

EXTENDS

FALSE

FETCH

FLOAT*

FOR*

FORALL

FROM*

FUNCTION

GOTO

GROUP*

HAVING*

HEAP

HOUR

IF

IMMEDIATE*

IN*

INDEX*

INDICATOR

INSERT*

INTEGER*

INTERFACE

INTERSECT*

INTERVAL

INTO*

IS*

ISOLATION

JAVA

LEVEL*

LIKE*

LIMITED

LOCK*

LONG*

LOOP

MAX

MIN

MINUS*

MINUTE

MLSLABEL*

MOD

MODE*

MONTH

NATURAL

NATURALN

NEW

NEXTVAL

NOCOPY

NOT*

NOWAIT*

NULL*

NUMBER*

NUMBER_BASE

OCIROWID

OF*

ON*

OPAQUE

OPEN

OPERATOR

OPTION*

OR*

ORDER*

ORGANIZATION

OTHERS

OUT

PACKAGE

PARTITION

PCTFREE*

PLS_INTEGER

POSITIVE

POSITIVEN

PRAGMA

PRIOR*

PRIVATE

PROCEDURE

PUBLIC*

RAISE

RANGE

RAW*

REAL

RECORD

REF

RELEASE

RETURN

REVERSE

ROLLBACK

ROW*

ROWID*

ROWNUM*

ROWTYPE

SAVEPOINT

SECOND

SELECT*

SEPARATE

SET*

SHARE*

SMALLINT*

SPACE

SQL

SQLCODE

SQLERRM

START*

STDDEV

SUBTYPE

SUCCESSFUL*

SUM

SYNONYM*

SYSDATE*

TABLE*

THEN*

TIME

TIMESTAMP

TO*

TRIGGER*

TRUE

TYPE

UID*

UNION*

UNIQUE*

UPDATE*

USE

USER*

VALIDATE*

VALUES*

VARCHAR*

VARCHAR2*

VARIANCE

VIEW*

WHEN

WHENEVER*

WHERE*

WHILE

WITH*