SQL Reserved Words

Previous
Previous
Next
Next

This section lists Oracle Database XE SQL Command Line reserved words. Words followed by an asterisk (*) are also ANSI reserved words.

Table: SQL Reserved Words lists the SQL reserved words.

SQL Reserved Words

Begins with: Reserved Words

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*, 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*, PRIVLEGES*, PUBLIC*

R

RAW, RENAME, RESOURCE, REVOKE*, ROW, ROWID, 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*