B
Reserved Words

This appendix lists the reserved words that should not be used to name objects in Oracle9i Warehouse Builder.

Reserved Words

Table B-1 lists reserved words in a columnar table which reads across the rows from top to bottom to conserve space. Do not use these words as physical object names within a Warehouse Builder Project.

Table B-1 Oracle Warehouse Builder Reserved Words  

ABORT	ACCEPT	ACCESS	ADD
ALL	ALTER	AND	ANY
ARRAY	ARRAYLEN	AS	ASC
ASSERT	ASSIGN	AT	AUDIT
AUTHORIZATION	AVG	BASE_TABLE	BEGIN
BETWEEN	BINARY_INTEGER	BODY	BOOLEAN
BY	CASE	CHAR	CHAR_BASE
CHECK	CLOSE	CLUSTER	CLUSTERS
COLAUTH	COLUMN	COMMENT	COMMIT
COMPRESS	CONNECT	CONSTANT	CRASH
CREATE	CURRENT	CURRVAL	CURSOR
DATA_BASE	DATABASE	DATE	DBA
DEBUGOFF	DEBUGON	DECIMAL	DECLARE
DEFAULT	DEFINITION	DELAY	DELETE
DELTA	DESC	DIGITS	DISPOSE
DISTINCT	DO	DROP	DUAL
ELSE	ELSIF	END	ENTRY
EXCEPTION	EXCEPTION_INIT	EXCLUSIVE	EXISTS
EXIT	FALSE	FETCH	FILE
FLOAT	FOR	FORM	FROM
FUNCTION	GENERIC	GOTO	GRANT
GROUP	HAVING	IDENTIFIED	IF
IMMEDIATE	IN	INCREMENT	INDEX
INDEXES	INDICATOR	INITIAL	INSERT
INTEGER	INTERFACE	INTERSECT	INTO
IS	LEVEL	LIKE	LIMITED
LOCK	LONG	LOOP	MAX
MAXEXTENTS	MIN	MINUS	MLSLABEL
MOD	MODE	MODIFY	NATURAL
NATURALN	NEW	NEXTVAL	NOAUDIT
NOCOMPRESS	NOT	NOWAIT	NULL
NUMBER	NUMBER_BASE	OF	OFFLINE
ON	ONLINE	OPEN	OPTION
OR	ORDER	OTHERS	OUT
PACKAGE	PARTITION	PCTFREE	PLS_INTEGER
POSITIVE	POSITIVEN	PRAGMA	PRIOR
PRIVATE	PRIVILEGES	PROCEDURE	PUBLIC
RAISE	RANGE	RAW	REAL
RECORD	REF	RELEASE	REMR
RENAME	RESOURCE	RETURN	REVERSE
REVOKE	ROLLBACK	ROW	ROWID
ROWLABEL	ROWNUM	ROWS	ROWTYPE
RUN	SAVEPOINT	SELECT	SEPARATE
SESSION	SET	SIZE	SMALLINT
SPACE	SQL	SQLCODE	SQLERRM
START	STATEMENT	STDDEF*	STDDEV
SUBTYPE	SUCCESSFUL	SUM	SYNONYM
SYSDATE	TABAUTH	TABLE	TABLEDEF*
TABLEPAT*	TABLES	TASK	TERMINATE
TIME	THEN	TO	TRIGGER
TRUE	TYPE	UID	UNION
UNIQUE	UPDATE	USE	USER
USERDEF*	VALIDATE	VALUES	VARCHAR
VARCHAR2	VARIANCE	VIEW	WHEN
WHENEVER	WHERE	WHILE	WITH
WORK	WRITE	XOR	N/A

*The words STDDEF, TABLEDEF, TABLEPAT, and USERDEF are only reserved if you have purchased the Oracle9i Warehouse Builder Name and Address component and are performing parse table maintenance.