V$RESERVED_WORDS

V$RESERVED_WORDS displays a list of all SQL keywords. To determine whether a particular keyword is reserved in any way, check the RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI columns.

Column	Datatype	Description
KEYWORD	VARCHAR2(30)	Name of the keyword
LENGTH	NUMBER	Length of the keyword
RESERVED	VARCHAR2(1)	Indicates whether the keyword cannot be used as an identifier (Y) or whether the keyword is not reserved (N)
RES_TYPE	VARCHAR2(1)	Indicates whether the keyword cannot be used as a type name (Y) or whether the keyword is not reserved (N)
RES_ATTR	VARCHAR2(1)	Indicates whether the keyword cannot be used as an attribute name (Y) or whether the keyword is not reserved (N)
RES_SEMI	VARCHAR2(1)	Indicates whether the keyword is not allowed as an identifier in certain situations, such as in DML (Y) or whether the keyword is not reserved (N)
DUPLICATE	VARCHAR2(1)	Indicates whether the keyword is a duplicate of another keyword (Y) or whether the keyword is not a duplicate (N)

Note:

1.

select keyword

from V$RESERVED_WORDS

where reserved = 'Y'

order by keyword;

!

&

(

)

*

+

,

-

.

/

:

<

=

>

@

ALL

ALTER

AND

ANY

AS

ASC

BETWEEN

BY

CHAR

CHECK

CLUSTER

COMPRESS

CONNECT

CREATE

DATE

DECIMAL

DEFAULT

DELETE

DESC

DISTINCT

DROP

ELSE

EXCLUSIVE

EXISTS

FLOAT

FOR

FROM

GRANT

GROUP

HAVING

IDENTIFIED

IN

INDEX

INSERT

INTEGER

INTERSECT

INTO

IS

LIKE

LOCK

LONG

MINUS

MODE

NOCOMPRESS

NOT

NOWAIT

NULL

NUMBER

OF

ON

OPTION

OR

ORDER

PCTFREE

PRIOR

PUBLIC

RAW

RENAME

RESOURCE

REVOKE

SELECT

SET

SHARE

SIZE

SMALLINT

START

SYNONYM

TABLE

THEN

TO

TRIGGER

UNION

UNIQUE

UPDATE

VALUES

VARCHAR

VARCHAR2

VIEW

WHERE

WITH

[

]

^

|

(space)

Oracle data dictionary views

Oracle dynamic performance views