Skip Headers
Oracle® Database Express Edition 2 Day Developer Guide
10g Release 2 (10.2)

Part Number B25108-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B Reserved Words

This section lists the Oracle Database Express Edition (Oracle Database XE) SQL and PL/SQL reserved words and keywords. You should not use these words to name program or schema objects, such as constants, variables, cursors, columns, tables, or indexes.

The V$RESERVED_WORDS data dictionary view provides additional information about all keywords, including whether the keyword is always reserved or is reserved only for particular uses. For more information, refer to Oracle Database Reference.

This section contains the following topics:

SQL Reserved Words

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

Table B-1 lists the SQL reserved words.

Table B-1 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*


PL/SQL Reserved Words

The words listed in this section are reserved by PL/SQL. Some of these words are also reserved by SQL.

These words reserved by PL/SQL are classified as keywords or reserved words. See Table B-2 and Table B-3. Reserved words can never be used as identifiers. Keywords can be used as identifiers, but this is not recommended.

Table B-2 lists the PL/SQL reserved words.

Table B-2 PL/SQL Reserved Words

Begins with: Reserved Words

A

ALL, ALTER, AND, ANY, ARRAY, ARROW, AS, ASC, AT

B

BEGIN, BETWEEN, BY

C

CASE, CHECK, CLUSTERS, CLUSTER, COLAUTH, COLUMNS, COMPRESS, CONNECT, CRASH, CREATE, CURRENT

D

DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DISTINCT, DROP

E

ELSE, END, EXCEPTION, EXCLUSIVE, EXISTS

F

FETCH, FORM, FOR, FROM

G

GOTO, GRANT, GROUP

H

HAVING

I

IDENTIFIED, IF, IN, INDEXES, INDEX, INSERT, INTERSECT, INTO, IS

L

LIKE, LOCK

M

MINUS, MODE

N

NOCOMPRESS, NOT, NOWAIT, NULL

O

OF, ON, OPTION, OR, ORDER,OVERLAPS

P

PRIOR, PROCEDURE, PUBLIC

R

RANGE, RECORD, RESOURCE, REVOKE

S

SELECT, SHARE, SIZE, SQL, START, SUBTYPE

T

TABAUTH, TABLE, THEN, TO, TYPE

U

UNION, UNIQUE, UPDATE, USE

V

VALUES, VIEW, VIEWS

W

WHEN, WHERE, WITH


Table B-3 lists the PL/SQL keywords.

Table B-3 PL/SQL Keywords

Begins with: Keywords

A

A, ADD, AGENT, AGGREGATE, ARRAY, ATTRIBUTE, AUTHID, AVG

B

BFILE_BASE, BINARY, BLOB_BASE, BLOCK, BODY, BOTH, BOUND, BULK, BYTE

C

C, CALL, CALLING, CASCADE, CHAR, CHAR_BASE, CHARACTER, CHARSETFORM, CHARSETID, CHARSET, CLOB_BASE, CLOSE, COLLECT, COMMENT, COMMIT, COMMITTED, COMPILED, CONSTANT, CONSTRUCTOR, CONTEXT, CONVERT, COUNT, CURSOR, CUSTOMDATUM

D

DANGLING, DATA, DATE, DATE_BASE, DAY, DEFINE, DETERMINISTIC, DOUBLE, DURATION

E

ELEMENT, ELSIF, EMPTY, ESCAPE, EXCEPT, EXCEPTIONS, EXECUTE, EXIT, EXTERNAL

F

FINAL, FIXED, FLOAT, FORALL, FORCE, FUNCTION

G

GENERAL

H

HASH, HEAP, HIDDEN, HOUR

I

IMMEDIATE, INCLUDING, INDICATOR, INDICES, INFINITE, INSTANTIABLE, INT, INTERFACE, INTERVAL, INVALIDATE, ISOLATION

J

JAVA

L

LANGUAGE, LARGE, LEADING, LENGTH, LEVEL, LIBRARY, LIKE2, LIKE4, LIKEC, LIMIT, LIMITED, LOCAL, LONG, LOOP

M

MAP, MAX, MAXLEN, MEMBER, MERGE, MIN, MINUTE, MOD, MODIFY, MONTH, MULTISET

N

NAME, NAN, NATIONAL, NATIVE, NCHAR, NEW, NOCOPY, NUMBER_BASE

O

OBJECT, OCICOLL, OCIDATETIME, OCIDATE, OCIDURATION, OCIINTERVAL, OCILOBLOCATOR, OCINUMBER, OCIRAW, OCIREFCURSOR, OCIREF, OCIROWID, OCISTRING, OCITYPE, ONLY, OPAQUE, OPEN, OPERATOR, ORACLE, ORADATA, ORGANIZATION, ORLANY, ORLVARY, OTHERS, OUT, OVERRIDING

P

PACKAGE, PARALLEL_ENABLE, PARAMETER, PARAMETERS, PARTITION, PASCAL, PIPE, PIPELINED, PRAGMA, PRECISION, PRIVATE

R

RAISE, RANGE, RAW, READ, RECORD, REF, REFERENCE, REM, REMAINDER, RENAME, RESULT, RETURN, RETURNING, REVERSE, ROLLBACK, ROW

S

SAMPLE, SAVE, SAVEPOINT, SB1, SB2, SB4, SECOND, SEGMENT, SELF, SEPARATE, SEQUENCE, SERIALIZABLE, SET, SHORT, SIZE_T, SOME, SPARSE, SQLCODE, SQLDATA, SQLNAME, SQLSTATE, STANDARD, STATIC, STDDEV, STORED, STRING, STRUCT, STYLE, SUBMULTISET, SUBPARTITION, SUBSTITUTABLE, SUBTYPE, SUM, SYNONYM

T

TDO, THE, TIME, TIMESTAMP, TIMEZONE_ABBR, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TRAILING, TRANSAC, TRANSACTIONAL, TRUSTED, TYPE

U

UB1, UB2, UB4, UNDER, UNSIGNED, UNTRUSTED, USE, USING

V

VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID

W

WHILE, WORK, WRAPPED, WRITE

Y

YEAR

Z

ZONE