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.  S
QL 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*