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