New Oracle8 SQL Key and Reserved Words

This appendix lists the several keywords and the one reserved word that are added new to Oracle8.

Problems can arise from possible existing uses of these special words as names for database objects (tables, columns), which normally should not be named using reserved words. Although the wise DBA tries to avoid problems that can arise from using keywords, reserved words as names for database objects (tables, columns, and such), which normally should not be named using reserved words.

Generally you should avoid naming your tables or 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 or columns that have these names must also be specified in double quotation marks. The special characters, reserved words, and key words new to Oracle8 are listed on the following page. All new Oracle8 words are key words except for one reserved word (VALUE).:



ACCOUNT	NCLOB
ARRAY	NESTED
BFILE	NOLOGGING
BLOB	NOPARALLEL
CAST	NOREVERSE
CFILE	NORMAL
CHAR_CS	NVARCHAR2
CHUNK	OBJECT
CLOB	OBJNO_REUSE
CLONE	OID
DANGLING	OIDINDEX
DATAOBJNO	ORGANIZATION
DEFERRABLE	OVERFLOW
DEFERRED	PASSWORD
DEREF	PCTTHRESHOLD
DIRECTORY	PCTVERSION
ENFORCE	PRESERVE
EXCHANGE	PURGE
EXPIRE	QUEUE
EXTENT	REF
FLOB	REPLACE
GLOBALLY	RETURN
HASH	RETURNING
HASHKEYS	REVERSE
HEAP	SCOPE
IDGENERATORS	SEG_BLOCK
INITIALLY	SEG_FILE
LIBRARY	SKIP
LOCKED	SYS_OP_NTCIMG
LOGGING	THAN
LOGICAL_READS_PER_CALL	THE
LOGICAL_READS_PER_SESSION	TOPLEVEL
MASTER	UNLOCK
NATIONAL	USAGE
NCHAR	VALUE (Reserved Word)
NCHAR_CS	VARYING

Library

Product

Contents

Index