Tuesday, September 2, 2008

Oracle SQL Reserved Words

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

UNION

UNIQUE

UPDATE

USER

V

VALIDATE

VALUES

VARCHAR

VARCHAR2

VIEW

W

WHENEVER

WHERE

WITH

No comments:

Post a Comment