D
New SQL Key and Reserved Words

This appendix lists several new keywords and one new reserved word added to version 8.

Problems can arise if these special words are used as names for database objects (tables, columns, etc.). In addition, 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 Oracle8 SQL Reference for the words that are reserved by SQL. Tables or columns that have these names also must be specified in double quotation marks. The special characters, reserved words, and keywords new to version 8 are listed below. All new version 8 words are keywords 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

---