C
Oracle8 Reserved Words, Keywords, and Namespaces
This appendix lists words that have a special meaning to Oracle8. Each word plays a specific role in the context in which it appears. For example, in an INSERT statement, the reserved word INTO introduces the tables to which rows will be added. But, in a FETCH or SELECT statement, the reserved word INTO introduces the output host variables to which column values will be assigned.
Topics are:
Oracle8 Reserved Words and Keywords
|
|
|
|
&
|
:
|
|
,
|
-
|
=
|
|
>
|
[
|
<
|
|
(
|
.
|
+
|
|
]
|
)
|
!
|
|
/
|
*
|
^
|
|
@
|
|
ACCESS
|
|
ACCOUNT
|
ACTIVATE
|
ADD
|
|
ADMIN
|
ADVISE
|
AFTER
|
|
ALL
|
ALL_ROWS
|
ALLOCATE
|
|
ALTER
|
ANALYZE
|
AND
|
|
ANY
|
ARCHIVE
|
ARCHIVELOG
|
|
ARRAY
|
AS
|
ASC
|
|
AT
|
AUDIT
|
AUTHENTICATED
|
|
AUTHORIZATION
|
AUTOEXTEND
|
AUTOMATIC
|
|
BACKUP
|
BECOME
|
BEFORE
|
|
BEGIN
|
BETWEEN
|
BFILE
|
|
BITMAP
|
BLOB
|
BLOCK
|
|
BODY
|
BY
|
CACHE
|
|
CACHE_INSTANCES
|
CANCEL
|
CASCADE
|
|
CAST
|
CFILE
|
CHAINED
|
|
CHANGE
|
CHAR
|
CHAR_CS
|
|
CHARACTER
|
CHECK
|
CHECKPOINT
|
|
CHOOSE
|
CHUNK
|
CLEAR
|
|
CLOB
|
CLONE
|
CLOSE
|
|
CLOSE_CACHED_OPEN_CURSORS
|
CLUSTER
|
COALESCE
|
|
COLUMN
|
COLUMNS
|
COMMENT
|
|
COMMIT
|
COMMITTED
|
COMPATIBILITY
|
|
COMPILE
|
COMPLETE
|
COMPOSITE_LIMIT
|
|
COMPRESS
|
COMPUTE
|
CONNECT
|
|
CONNECT_TIME
|
CONSTRAINT
|
CONSTRAINTS
|
|
CONTENTS
|
CONTINUE
|
CONTROLFILE
|
|
CONVERT
|
COST
|
CPU_PER_CALL
|
|
CPU_PER_SESSION
|
CREATE
|
CURRENT
|
|
CURRENT_SCHEMA
|
CURRENT_USER
|
CURSOR
|
|
CYCLE
|
DANGLING
|
DATABASE
|
|
DATAFILE
|
DATAFILES
|
DATAOBJNO
|
|
DATE
|
DBA
|
DBHIGH
|
|
DBLOW
|
DBMAC
|
DEALLOCATE
|
|
DEBUG
|
DEC
|
DECIMAL
|
|
DECLARE
|
DEFAULT
|
DEFERRABLE
|
|
DEFERRED
|
DEGREE
|
DELETE
|
|
DEREF
|
DESC
|
DIRECTORY
|
|
DISABLE
|
DISCONNECT
|
DISMOUNT
|
|
DISTINCT
|
DISTRIBUTED
|
DML
|
|
DOUBLE
|
DROP
|
DUMP
|
|
EACH
|
ELSE
|
ENABLE
|
|
END
|
ENFORCE
|
ENTRY
|
|
ESCAPE
|
ESTIMATE
|
EVENTS
|
|
EXCEPT
|
EXCEPTIONS
|
EXCHANGE
|
|
EXCLUDING
|
EXCLUSIVE
|
EXECUTE
|
|
EXISTS
|
EXPIRE
|
EXPLAIN
|
|
EXTENT
|
EXTENTS
|
EXTERNALLY
|
|
FAILED_LOGIN_ATTEMPTS
|
FALSE
|
FAST
|
|
FILE
|
FIRST_ROWS
|
FLAGGER
|
|
FLOAT
|
FLOB
|
FLUSH
|
|
FOR
|
FORCE
|
FOREIGN
|
|
FREELIST
|
FREELISTS
|
FROM
|
|
FULL
|
FUNCTION
|
|
|
GLOBAL
|
GLOBALLY
|
GLOBAL_NAME
|
|
GRANT
|
GROUP
|
GROUPS
|
|
HASH
|
HASHKEYS
|
HAVING
|
|
HEADER
|
HEAP
|
IDENTIFIED
|
|
IDGENERATORS
|
IDLE_TIME
|
IF
|
|
IMMEDIATE
|
IN
|
INCLUDING
|
|
INCREMENT
|
INDEX
|
INDEXED
|
|
INDEXES
|
INDICATOR
|
IND_PARTITION
|
|
INITIAL
|
INITIALLY
|
INITRANS
|
|
INSERT
|
INSTANCE
|
INSTANCES
|
|
INSTEAD
|
INT
|
INTEGER
|
|
INTERMEDIATE
|
INTERSECT
|
INTO
|
|
IS
|
ISOLATION
|
ISOLATION_LEVEL
|
|
KEEP
|
KEY
|
KILL
|
|
LABEL
|
LAYER
|
LESS
|
|
LEVEL
|
LIBRARY
|
LIKE
|
|
LIMIT
|
LINK
|
LIST
|
|
LOB
|
LOCAL
|
LOCK
|
|
LOCKED
|
LOG
|
LOGFILE
|
|
LOGGING
|
LOGICAL_READS_PER_CALL
|
LOGICAL_READS_PER_SESSION
|
|
LONG
|
MANAGE
|
MASTER
|
|
MAX
|
MAXARCHLOGS
|
MAXDATAFILES
|
|
MAXEXTENTS
|
MAXINSTANCES
|
MAXLOGFILES
|
|
MAXLOGHISTORY
|
MAXLOGMEMBERS
|
MAXSIZE
|
|
MAXTRANS
|
MAXVALUE
|
MIN
|
|
MEMBER
|
MINIMUM
|
MINEXTENTS
|
|
MINUS
|
MINVALUE
|
MLSLABEL
|
|
MLS_LABEL_FORMAT
|
MODE
|
MODIFY
|
|
MOUNT
|
MOVE
|
MTS_DISPATCHERS
|
|
MULTISET
|
NATIONAL
|
NCHAR
|
|
NCHAR_CS
|
NCLOB
|
NEEDED
|
|
NESTED
|
NETWORK
|
NEW
|
|
NEXT
|
NOARCHIVELOG
|
NOAUDIT
|
|
NOCACHE
|
NOCOMPRESS
|
NOCYCLE
|
|
NOFORCE
|
NOLOGGING
|
NOMAXVALUE
|
|
NOMINVALUE
|
NONE
|
NOORDER
|
|
NOOVERRIDE
|
NOPARALLEL
|
NORESETLOGS
|
|
NOREVERSE
|
NORMAL
|
NOSORT
|
|
NOT
|
NOTHING
|
NOWAIT
|
|
NULL
|
NUMBER
|
NUMERIC
|
|
NVARCHAR2
|
OBJECT
|
OBJNO
|
|
OBJNO_REUSE
|
OF
|
OFF
|
|
OFFLINE
|
OID
|
OIDINDEX
|
|
OLD
|
ON
|
ONLINE
|
|
ONLY
|
OPCODE
|
OPEN
|
|
OPTIMAL
|
OPTIMIZER_GOAL
|
OPTION
|
|
OR
|
ORDER
|
ORGANIZATION
|
|
OSLABEL
|
OVERFLOW
|
OWN
|
|
PACKAGE
|
PARALLEL
|
PARTITION
|
|
PASSWORD
|
PASSWORD_GRACE_TIME
|
PASSWORD_LIFE_TIME
|
|
PASSWORD_LOCK_TIME
|
PASSWORD_REUSE_MAX
|
PASSWORD_REUSE_TIME
|
|
PASSWORD_VERIFY_FUNCTION
|
PCTFREE
|
PCTINCREASE
|
|
PCTTHRESHOLD
|
PCTUSED
|
PCTVERSION
|
|
PERCENT
|
PERMANENT
|
PLAN
|
|
PLSQL_DEBUG
|
POST_TRANSACTION
|
PRECISION
|
|
PRESERVE
|
PRIMARY
|
PRIOR
|
|
PRIVATE
|
PRIVATE_SGA
|
PRIVILEGE
|
|
PRIVILEGES
|
PROCEDURE
|
PROFILE
|
|
PUBLIC
|
PURGE
|
QUEUE
|
|
QUOTA
|
RANGE
|
RAW
|
|
RBA
|
READ
|
READUP
|
|
REAL
|
REBUILD
|
RECOVER
|
|
RECOVERABLE
|
RECOVERY
|
REF
|
|
REFERENCES
|
REFERENCING
|
REFRESH
|
|
RENAME
|
REPLACE
|
RESET
|
|
RESETLOGS
|
RESIZE
|
RESOURCE
|
|
RESTRICTED
|
RETURN
|
RETURNING
|
|
REUSE
|
REVERSE
|
REVOKE
|
|
ROLE
|
ROLES
|
ROLLBACK
|
|
ROW
|
ROWID
|
ROWNUM
|
|
ROWS
|
RULE
|
SAMPLE
|
|
SAVEPOINT
|
SB4
|
SCAN_INSTANCES
|
|
SCHEMA
|
SCN
|
SCOPE
|
|
SD_ALL
|
SD_INHIBIT
|
SD_SHOW
|
|
SEGMENT
|
SEG_BLOCK
|
SEG_FILE
|
|
SELECT
|
SEQUENCE
|
SERIALIZABLE
|
|
SESSION
|
SESSION_CACHED_CURSORS
|
SESSIONS_PER_USER
|
|
SET
|
SHARE
|
SHARED
|
|
SHARED_POOL
|
SHRINK
|
SIZE
|
|
SKIP
|
SKIP_UNUSABLE_INDEXES
|
SMALLINT
|
|
SNAPSHOT
|
SOME
|
SORT
|
|
SPECIFICATION
|
SPLIT
|
SQL_TRACE
|
|
STANDBY
|
START
|
STATEMENT_ID
|
|
STATISTICS
|
STOP
|
STORAGE
|
|
STORE
|
STRUCTURE
|
SUCCESSFUL
|
|
SWITCH
|
SYS_OP_ENFORCE_NOT_NULL$
|
SYS_OP_NTCIMG$
|
|
SYNONYM
|
SYSDATE
|
SYSDBA
|
|
SYSOPER
|
SYSTEM
|
TABLE
|
|
TABLES
|
TABLESPACE
|
TABLESPACE_NO
|
|
TABNO
|
TEMPORARY
|
THAN
|
|
THE
|
THEN
|
THREAD
|
|
TIMESTAMP
|
TIME
|
TO
|
|
TOPLEVEL
|
TRACE
|
TRACING
|
|
TRANSACTION
|
TRANSITIONAL
|
TRIGGER
|
|
TRIGGERS
|
TRUE
|
TRUNCATE
|
|
TX
|
TYPE
|
UB2
|
|
UBA
|
UID
|
UNARCHIVED
|
|
UNDO
|
UNION
|
UNIQUE
|
|
UNLIMITED
|
UNLOCK
|
UNRECOVERABLE
|
|
UNTIL
|
UNUSABLE
|
UNUSED
|
|
UPDATABLE
|
UPDATE
|
USAGE
|
|
USE
|
USER
|
USING
|
|
VALIDATE
|
VALIDATION
|
VALUE
|
|
VALUES
|
VARCHAR
|
VARCHAR2
|
|
VARYING
|
VIEW
|
WHEN
|
|
WHENEVER
|
WHERE
|
WITH
|
|
WITHOUT
|
WORK
|
WRITE
|
|
WRITEDOWN
|
WRITEUP
|
XID
|
Oracle8 Reserved Namespaces
Table C-1 contains a list of namespaces that are reserved by Oracle8. The initial characters of function names in Oracle8 libraries are restricted to the character strings in this list. Because of potential name conflicts, use function names that do not begin with these characters.
For example, the SQL*Net Transparent Network Service functions all begin with the characters "NS," so you need to avoid writing functions whose names begin with "NS."
Table C-1 Oracle8 Reserved Namespaces
|
Namespace
|
Library
|
|---|
|
O
|
OCI functions
|
|
S
|
function names from SQLLIB and system-dependent libraries
|
|
XA
|
external functions for XA applications only
|
|
GEN
KP
L
NA
NC
ND
NL
NM
NR
NS
NT
NZ
TTC
UPI
|
Internal functions
|
