Appendix C. Oracle PL/SQL Reserved Words and Keywords

Oracle PL/SQL is made up of keywords—special words that are used in performing SQL operations. Special care must be taken to not use these keywords when naming databases, tables, columns, and any other database objects.

ALL

ALTER

AND

ANY

ARRAY

ARROW

AS

ASC

AT

BEGIN

BETWEEN

BY

CASE

CHECK

CLUSTER

CLUSTERS

COLAUTH

COLUMNS

COMPRESS

CONNECT

CRASH

CREATE

CURRENT

DECIMAL

DECLARE

DEFAULT

DELETE

DESC

DISTINCT

DROP

ELSE

END

EXCEPTION

EXCLUSIVE

EXISTS

FETCH

FOR

FORM

FROM

GOTO

GRANT

GROUP

HAVING

IDENTIFIED

IF

IN

INDEX

INDEXES

INSERT

INTERSECT

INTO

IS

LIKE

LOCK

MINUS

MODE

NOCOMPRESS

NOT

NOWAIT

NULL

OF

ON

OPTION

OR

ORDER,OVERLAPS

PRIOR

PROCEDURE

PUBLIC

RANGE

RECORD

RESOURCE

REVOKE

SELECT

SHARE

SIZE

SQL ...

Get Oracle PL/SQL in 10 Minutes, Sams Teach Yourself now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.