Oracle8i Utilities
Release 8.1.5

A67792-01

Library

Product

Contents

Index

Prev Next

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.

Reserved Word List and Information

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 Oracle8i 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  

APPEND  

BADDN  

BADFILE  

BEGINDATA  

BFILE  

BLANKS  

BLOCKSIZE  

BY  

BYTEINT  

CHAR  

CHARACTERSET  

COLUMN  

CONCATENATE  

CONSTANT  

CONTINUE_LOAD  

CONTINUEIF  

COUNT  

DATA  

DATE  

DECIMAL  

DEFAULTIF  

DELETE  

DISABLED_CONSTRAINTS  

DISCARDDN  

DISCARDFILE  

DISCARDMAX  

DISCARDS  

DOUBLE  

ENCLOSED  

EOF  

EXCEPTIONS  

EXTERNAL  

FIELDS  

FILLER  

FIXED  

FLOAT  

FORMAT  

GENERATED  

GRAPHIC  

INDDN  

INDEXES  

INFILE  

INSERT  

INTEGER  

INTO  

LAST  

LOAD  

LOBFILE  

LOG  

LONG  

MAX  

MLSLABEL  

NESTED  

NEXT  

NO  

NULLCOLS  

NULLIF  

OBJECT  

OID  

OPTIONALLY  

OPTIONS  

PART  

PARTITION  

PIECED  

POSITION  

PRESERVE  

RAW  

READBUFFERS  

READSIZE  

RECLEN  

RECNUM  

RECORD  

RECOVERABLE  

REENABLE  

REF  

REPLACE  

RESUME  

SDF  

SEQUENCE  

SID  

SINGLEROW  

SKIP  

SMALLINT  

SORTDEVT  

SORTED  

SORTNUM  

SQL/DS  

STORAGE  

STREAM  

SUBPARTITION  

SYSDATE  

TABLE  

TERMINATED  

THIS  

TRAILING  

TRUNCATE  

UNLOAD  

UNRECOVERABLE  

USING  

VARCHAR  

VARCHARC  

VARGRAPHIC  

VARIABLE  

VARRAW  

VARRAWC  

VARRAY  

WHEN  

WHITESPACE  

WORKDDN  

YES  

ZONED  

 

 




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index