Oracle8i Utilities
Release 2 (8.1.6)

Part Number A76955-01

Library

Product

Contents

Index

Go to previous page Go to next page

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 usually should not be named using reserved words.

Reserved Word List and Information

Some languages and utilities have reserved words. The reserved words have special meanings to that language or utility. Generally you should avoid naming your tables and columns using words that are reserved by any of the languages or utilities you are likely to use. 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 SQL reserved words as their names must have those names specified in double quotation marks.

Because the following words have special meanings for SQL*Loader, Oracle Corporation recommends that you do not use them as names for tables or columns. If you do use them, the names should be enclosed in double quotation marks.

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  

 

 



Go to previous page
Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index