Oracle8 Migration Release 8.0 A58243-01 |
Library | Product | Contents | Index

# 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

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index