This view gives 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) |
A value of Y means that the keyword cannot be used as an identifier. A value of N means that it is not reserved. |
RES_TYPE |
VARCHAR2(1) |
A value of Y means that the keyword cannot be used as a type name. A value of N means that it is not reserved. |
RES_ATTR |
VARCHAR2(1) |
A value of Y means that the keyword cannot be used as an attribute name. A value of N means that it is not reserved. |
RES_SEMI |
VARCHAR2(1) |
A value of Y means that the keyword is not allowed as an identifier in certain situations, such as in DML. A value of N means that it is not reserved. |
DUPLICATE |
VARCHAR2(1) |
A value of Y means that the keyword is a duplicate of another keyword. A value of N means that it is not a duplicate. |