Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
The following table lists the reserved keywords in Oracle mode of OceanBase Database.
The following table lists the reserved keywords in Oracle mode of OceanBase Database.
| Letter | ||||
|---|---|---|---|---|
| A | ACCESS | ADD | ALL | ALTER |
| AND | ANY | AS | ASC | |
| AUDIT | ||||
| B | BETWEEN | BY | ||
| C | CHAR | CHECK | CLUSTER | COLUMN |
| COMMENT | COMPRESS | CONNECT | CREATE | |
| CURRENT | CASE | CONNECT_BY_ROOT | ||
| D | DATE | DECIMAL | DEFAULT | DELETE |
| DESC | DISTINCT | DROP | DUAL | |
| E | ELSE | EXCLUSIVE | EXISTS | |
| F | 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 |
| RAW | ||||
| R | RENAME | RESOURCE | REVOKE | ROW |
| ROWID | ROWLABEL | ROWNUM | ROWS | |
| S | START | SELECT | SESSION | SET |
| SHARE | SIZE | SMALLINT | SUCCESSFUL | |
| SYNONYM | SYSDATE | SQL_CALC_FOUND_ROWS | ||
| T | TABLE | THEN | TO | TRIGGER |
| U | UID | UNION | UNIQUE | UPDATE |
| USER | ||||
| V | VALIDATE | VALUES | VARCHAR | VARCHAR2 |
| VIEW | ||||
| W | WHENEVER | WHERE | WITH |
