Note
This view is available starting with V5.0.1.
Overview
Displays keyword information.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| KEYWORD | VARCHAR2(128) | NO | Represents the keyword name. |
| LENGTH | NUMBER | NO | Represents the length of the keyword. |
| TYPE | VARCHAR2(16) | NO | Indicates the syntax category of the keyword. Valid values:
|
| RESERVED | NUMBER(38) | NO | Indicates whether the word is a reserved keyword. Valid values:
|
Sample query
Retrieves information about a keyword.
obclient> SELECT * FROM SYS.V$OB_KEYWORDS WHERE ROWNUM = 1\G
The query result is as follows:
*************************** 1. row ***************************
KEYWORD: access
LENGTH: 6
TYPE: SQL
RESERVED: 1
1 row in set