Oracle8 Utilities Release 8.0 A58244-01 |
Library | Product | Contents | Index

# A
SQL*Loader Reserved Words

This appendix lists the words reserved for use 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 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 | USING
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 |

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index