Oracle® Database Express Edition 2 Day Developer Guide 10g Release 2 (10.2) Part Number B25108-01 |
|
|
View PDF |
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:
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* |
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 |