Oracle8 Utilities
Release 8.0

A58244-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.

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
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index