Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
The following reserved keywords are used in OceanBase Database's Oracle mode.
The table below lists these reserved keywords in a structured manner for clarity and readability:
| 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 |
| LOG | ||||
| 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 |