PL SQL keywords

Reserved words and keywords are identifiers that have special meaning in PL/SQL. They are case-insensitive.  You cannot use reserved words as ordinary user-defined identifiers. For more information about them, see "ReservedWords and Keywords"

Note: Some of the words in this appendix are also reserved by SQL.You can display them with the dynamic performance view V$RESERVED_WORDS. For information about this view, see Oracle Database Reference.

PL/SQL Keywords

Begins with:      Keywords

A       A, ADD, AGENT, AGGREGATE, ARRAY,

ATTRIBUTE, AUTHID, AVG

B       BFILE_BASE, BINARY, BLOB_BASE, BLOCK, BODY,

BOTH, BOUND, BULK, BYTE

C       C, CALL, CALLING, CASCADE, CHAR, CHAR_BASE,

CHARACTER, CHARSET, CHARSETFORM,

CHARSETID, CLOB_BASE, CLOSE, COLLECT, COMMENT,

COMMIT, COMMITTED, COMPILED,

CONSTANT, CONSTRUCTOR, CONTEXT, CONTINUE,

CONVERT, COUNT, CURRENT,

CUSTOMDATUM

D       DANGLING, DATA, DATE, DATE_BASE, DAY, DEFINE, DELETE,

DETERMINISTIC, DOUBLE,

DURATION

E       ELEMENT, ELSIF, EMPTY, ESCAPE, EXCEPT, EXCEPTIONS,

EXECUTE, EXISTS, EXIT, EXTERNAL

F       FINAL, FIXED, FLOAT, FORALL, FORCE

G       GENERAL

H       HASH, HEAP, HIDDEN, HOUR

I         IMMEDIATE, INCLUDING, INDICATOR, INDICES,

INFINITE, INSTANTIABLE, INT, INTERFACE,

INTERVAL, INVALIDATE, ISOLATION

J        JAVA

L        LANGUAGE, LARGE, LEADING, LENGTH, LEVEL, LIBRARY,

LIKE2, LIKE4, LIKEC, LIMIT, LIMITED,

LOCAL, LONG, LOOP

M        MAP, MAX, MAXLEN, MEMBER, MERGE, MIN, MINUTE,

MOD, MODIFY, MONTH, MULTISET

N        NAME, NAN, NATIONAL, NATIVE, NCHAR,

NEW, NOCOPY, NUMBER_BASE

O        OBJECT, OCICOLL, OCIDATE, OCIDATETIME, OCIDURATION,

OCIINTERVAL, OCILOBLOCATOR,

OCINUMBER, OCIRAW, OCIREF, OCIREFCURSOR, OCIROWID,

OCISTRING, OCITYPE, OLD, ONLY,

OPAQUE, OPEN, OPERATOR, ORACLE, ORADATA, ORGANIZATION,

ORLANY, ORLVARY, OTHERS, OUT, OVERRIDING

P         PACKAGE, PARALLEL_ENABLE, PARAMETER, PARAMETERS,

PARENT, PARTITION, PASCAL, PIPE,

PIPELINED, PRAGMA, PRECISION, PRIOR, PRIVATE

R         RAISE, RANGE, RAW, READ, RECORD, REF, REFERENCE,

RELIES_ON, REM, REMAINDER, RENAME,

RESULT, RESULT_CACHE, RETURN, RETURNING, REVERSE,

ROLLBACK, ROW

S          SAMPLE, SAVE, SAVEPOINT, SB1, SB2,              SB4, SECOND, SEGMENT,

SELF, SEPARATE, SEQUENCE,

SERIALIZABLE, SET, SHORT, SIZE_T, SOME, SPARSE,

SQLCODE, SQLDATA, SQLNAME, SQLSTATE,

STANDARD, STATIC, STDDEV, STORED, STRING, STRUCT,

STYLE, SUBMULTISET, SUBPARTITION,

SUBSTITUTABLE, SUM, SYNONYM

T                 TDO, THE, TIME, TIMESTAMP, TIMEZONE_ABBR,

TIMEZONE_HOUR, TIMEZONE_MINUTE,

TIMEZONE_REGION, TRAILING, TRANSACTION,

TRANSACTIONAL, TRUSTED

U                 UB1, UB2, UB4, UNDER, UNSIGNED,

UNTRUSTED, USE, USING

V                 VALIST, VALUE, VARIABLE, VARIANCE,

VARRAY, VARYING, VOID

W                WHILE, WORK, WRAPPED, WRITE

Y                 YEAR

Z                  ZONE

 PL/SQL Reserved Words

Begins with:          Reserved Words

A      ALL, ALTER, AND, ANY, AS, ASC, AT

B      BEGIN, BETWEEN, BY

C      CASE, CHECK, CLUSTERS, CLUSTER, COLAUTH,

COLUMNS, COMPRESS, CONNECT, CRASH, CREATE,

CURSOR

D      DECLARE, DEFAULT, DESC, DISTINCT, DROP

E      ELSE, END, EXCEPTION, EXCLUSIVE

F      FETCH, FOR, FROM, FUNCTION

G     GOTO, GRANT, GROUP

H     HAVING

I       IDENTIFIED, IF, IN, INDEX, INDEXES,

INSERT, INTERSECT, INTO, IS

L      LIKE, LOCK

M     MINUS, MODE

N     NOCOMPRESS, NOT, NOWAIT, NULL

O     OF, ON, OPTION, OR, ORDER, OVERLAPS

P      PROCEDURE, PUBLIC

R      RESOURCE, REVOKE

S      SELECT, SHARE, SIZE, SQL, START, SUBTYPE

T      TABAUTH, TABLE, THEN, TO, TYPE

U      UNION, UNIQUE, UPDATE

V      VALUES, VIEW, VIEWS

W     WHEN, WHERE,WITH