- Operators
- Functions
- Format Models
- Reserved Words
- Priviledges
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 |
VIEW |
COMMENT |
FROM |
LONG |
PCTFREE |
START |
WHENEVER |
COMPRESS |
GRANT |
MAXEXTENTS |
PRIOR |
SUCCESSFUL |
WHERE |
CONNECT |
GROUP |
MINUS |
PRIVILEGES |
SYNONYM |
WITH |