Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only 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.
| 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 |