The following is a list of Oracle SQL reserved words. A name cannot use any of these words. Note: In addition to the following reserved words, Oracle uses system-generated names that begin with SYS_ for implicitly generated schema objects and subobjects. You should avoid using this prefix in any names you explicity create to avoid confusion in name resolution.
| A | | |
| ACCESS | ADD | ALL |
| ALTER | AND | ANY |
| AS | ASC | AUDIT |
| B | | |
| BETWEEN | BY | |
| C | | |
| CHAR | CHECK | CLUSTER |
| COLUMN | COMMENT | COMPRESS |
| CONNECT | CREATE | CURRENT |
| D | | |
| DATE | DECIMAL | DEFAULT |
| DELETE | DESC | DISTINCT |
| DROP | | |
| 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 | MLSLABEL |
| MODE | MODIFY | |
| N | | |
| NOAUDIT | NOCOMPRESS | NOT |
| NOWAIT | NULL | NUMBER |
| O | | |
| OF | OFFLINE | ON |
| ONLINE | OPTION | OR |
| ORDER | | |
| P | | |
| PCTREE | PRIOR | PRIVILEGES |
| PUBLIC | | |
| R | | |
| RAW | RENAME | RESOURCE |
| REVOKE | ROW | ROWID |
| ROWLABEL | ROWNUM | ROWS |
| S | | |
| SELECT | SESSION | SET |
| SHARE | SIZE | SMALLINT |
| START | SUCCESSFUL | SYNONYM |
| SYSDATE | | |
| T | | |
| TABLE | THEN | TO |
| TRIGGER | | |
| U | | |
| UID | | UNIQUE |
| UPDATE | USER | |
| V | | |
| VALIDATE | VALUES | VARCHAR |
| VARCHAR2 | VIEW | |
| W | | |
| WHENEVER | WHERE | WITH |
No comments:
Post a Comment