SQL*Loader Reserved Words

This appendix lists the words reserved by the Oracle utilities. It also explains how to avoid problems that can arise from using reserved words as names for tables and columns, which normally should not be named using reserved words.

Generally you should avoid naming your tables and columns using terms that are reserved by any of the languages or utilities you are likely to use at your installation. Refer to the various language and reference manuals and to this appendix for lists of reserved words.

Consult the Oracle8 Server SQL Reference for a list of words that are reserved by SQL. Tables and columns that have these names must have these names specified in double quotation marks.

When using SQL*Loader, you must follow the usual rules for naming tables and columns. A table or column's name cannot be a reserved word, a word having special meaning for SQL*Loader. The following words must be enclosed in double quotation marks to be used as a name for a table or column:



AND	FLOAT	RECOVERABLE
APPEND	FORMAT	REENABLE
BADFILE	GENERATED	REPLACE
BADDN	GRAPHIC	RESUME
BEGINDATA	INDDN	SEQUENCE
BLANKS	INDEXES	SINGLEROW
BLOCKSIZE	INFILE	SKIP
BY	INSERT	SMALLINT
BYTEINT	INTEGER	SORTDEVT
CHAR	INTO	SORTED
CHARACTERSET	LAST	SORTNUM
CONCATENATE	LOAD	SQL/DS
CONSTANT	LOG	STORAGE
CONTINUE_LOAD	MAX	STREAM
CONTINUEIF	MLSLABEL	SYSDATE
COUNT	NEXT	TABLE
DATA	NO	TERMINATED
DATE	NULLCOLS	THIS
DECIMAL	NULLIF	TRAILING
DEFAULTIF	OPTIONALLY	TRUNCATE
DELETE	OPTIONS	UNLOAD
DISABLED_CONSTRAINTS	PARALLEL	UNRECOVERABLE
DISCARDDN	PART	USINGS
DISCARDFILE	PARTITION	VARCHAR
DISCARDMAX	PIECED	VARGRAPHIC
DISCARDS	POSITION	VARIABLE
DOUBLE	PRESERVE	WHEN
ENCLOSED	RAW	WHITESPACE
EXCEPTIONS	READBUFFERS	WORKDDN
EXTERNAL	RECLEN	YES
FIELDS	RECNUM	ZONED
FIXED	RECORD