C
Oracle Reserved Words

This appendix 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.

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

ROWID

ROWNUM

ROWS *

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 *