Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
The following table lists the reserved keywords in Oracle-compatible mode of OceanBase Database.
The following table lists the reserved keywords in Oracle-compatible mode of OceanBase Database.
Character |
||||
|---|---|---|---|---|
| A | ACCESS | ADD | ALL | ALTER |
| AND | ANY | AS | ASC | |
| AUDIT | ||||
| B | BETWEEN | BY | ||
| C | CASE | CHAR | CHECK | CLUSTER |
| COLUMN | COMMENT | COMPRESS | CONNECT | |
| CONNECT_BY_ROOT | CREATE | CURRENT | ||
| D | DATE | DECIMAL | DEFAULT | DELETE |
| DESC | DISTINCT | DROP | DUAL | |
| E | ELSE | EXCLUSIVE | EXISTS | |
| F | FALSE | FILE | FLOAT | FOR |
| FROM | ||||
| G | GRANT | GROUP | ||
| H | HAVING | |||
| I | IDENTIFIED | IMMEDIATE | IN | INCREMENT |
| INDEX | INITIAL | INSERT | INTEGER | |
| INTERSECT | INTO | IS | ||
| L | LEVEL | LIKE | LOCK | LONG |
| M | MAXEXTENTS | MINUS | MODE | MODIFY |
| N | NOAUDIT | NOCOMPRESS | NOT | NOTFOUND |
| NOWAIT | NULL | NUMBER | ||
| O | OF | OFFLINE | ON | ONLINE |
| OPTION | OR | ORDER | ||
| P | PCTFREE | PRIOR | PRIVILEGES | PUBLIC |
| R | RAW | RENAME | RESOURCE | REVOKE |
| ROW | ROWID | ROWLABEL | ROWNUM | |
| ROWS | ||||
| S | SELECT | SESSION | SET | SHARE |
| SIZE | SMALLINT | SQL_CALC_FOUND_ROWS | START | |
| SUCCESSFUL | SYNONYM | SYSDATE | ||
| T | TABLE | THEN | TO | TRIGGER |
| TRUE | ||||
| U | UID | UNION | UNIQUE | UPDATE |
| USER | ||||
| V | VALIDATE | VALUES | VARCHAR | VARCHAR2 |
| VARCHARACTER | VIEW | |||
| W | WHENEVER | WHERE | WITH |
Query keywords
You can also query the V$OB_KEYWORDS view to obtain the complete list of keywords for the current tenant, including reserved and non-reserved keywords. For more information about this view, see V$OB_KEYWORDS.
Reserved keywords for all SQL queries:
obclient> SELECT KEYWORD FROM sys.V$OB_KEYWORDS WHERE TYPE = 'SQL' AND RESERVED = 1 ORDER BY KEYWORD;Reserved keywords for all PL queries:
obclient> SELECT KEYWORD FROM sys.V$OB_KEYWORDS WHERE TYPE = 'PL' AND RESERVED = 1 ORDER BY KEYWORD;Check whether a specified identifier is a reserved keyword:
obclient> SELECT KEYWORD, TYPE, RESERVED FROM sys.V$OB_KEYWORDS WHERE KEYWORD = 'SELECT';