Reserved Words
The following are the reserved words in Oracle SQL. Those in italics are also ANSI reserved words. In addition, Oracle uses the “SYS_” prefix internally to identify implicitly generated schema objects and you should avoid the use of any words beginning with this prefix.
| ACCESS | CREATE | HAVING | MODE | PUBLIC | SYSDATE |
| ADD | CURRENT | IDENTIFIED | MODIFY | RAW | TABLE |
| ALL | DATE | IMMEDIATE | NOAUDIT | RENAME | THEN |
| ALTER | DECIMAL | IN | NOCOMPRESS | RESOURCE | TO |
| AND | DEFAULT | INCREMENT | NOT | REVOKE | TRIGGER |
| ANY | DELETE | INDEX | NOWAIT | ROW | UID |
| AS | DESC | INITIAL | NULL | ROWID | UNION |
| ASC | DISTINCT | INSERT | NUMBER | ROWNUM | UNIQUE |
| AUDIT | DROP | INTEGER | OF | ROWS | UPDATE |
| BETWEEN | ELSE | INTERSECT | OFFLINE | SELECT | USER |
| BY | EXCLUSIVE | INTO | ON | SESSION | VALIDATE |
| CHAR | EXISTS | IS | ONLINE | SET | VALUES |
| CHECK | FILE | LEVEL | OPTION | SHARE | VARCHAR |
| CLUSTER | FLOAT | LIKE | OR | SIZE | VARCHAR2 |
| COLUMN | FOR | LOCK | ORDER | SMALLINT ... |
Get Oracle® DBA SQL Quick Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
