oracle 8i 关键字列表

Oracle8 SQL Reference Release 8.0 A58225-01

---

Oracle Reserved Words and Keywords

This appendix lists Oracle reserved words and keywords.

lists Oracle reserved words. Words followed by an asterisk (*) are also ANSI reserved words.

Note: In addition to the following reserved words, Oracle uses system-generated names beginning with "SYS_" for implicitly generated schema objects and subobjects. Oracle discourages you from using this prefix in the names you explicitly provide to your schema objects and subobjects to avoid possible conflict in name resolution.

Table C-1 Reserved Words

ACCESS	AUDIT	COMPRESS	DESC*
ADD*	BETWEEN*	CONNECT*	DISTINCT*
ALL*	BY*	CREATE*	DROP*
ALTER*	CHAR*	CURRENT*	ELSE*
AND*	CHECK*	DATE*	EXCLUSIVE
ANY*	CLUSTER	DECIMAL*	EXISTS
AS*	COLUMN	DEFAULT*	FILE
ASC*	COMMENT	DELETE*	FLOAT*
FOR*	LONG	PCTFREE	SUCCESSFUL
FROM*	MAXEXTENTS	PRIOR*	SYNONYM
GRANT*	MINUS	PRIVILEGES*	SYSDATE
GROUP*	MODE	PUBLIC*	TABLE*
HAVING*	MODIFY	RAW	THEN*
IDENTIFIED	NETWORK	RENAME	TO*
IMMEDIATE*	NOAUDIT	RESOURCE	TRIGGER
IN*	NOCOMPRESS	REVOKE*	UID
INCREMENT	NOT*	ROW	UNION*
INDEX	NOWAIT	ROWID	UNIQUE*
INITIAL	NULL*	ROWNUM	UPDATE*
INSERT*	NUMBER	ROWS*	USER*
INTEGER*	OF*	SELECT*	VALIDATE
INTERSECT*	OFFLINE	SESSION*	VALUES*
INTO*	ON*	SET*	VARCHAR*
IS*	ONLINE	SHARE	VARCHAR2
LEVEL*	OPTION*	SIZE*	VIEW*
LIKE*	OR*	SMALLINT*	WHENEVER*
LOCK	ORDER*	START	WHERE
			WITH*

lists Oracle keywords. Keywords marked with asterisks (*) are also ANSI reserved words. For maximum portability to other implementations of SQL, do not use these words as schema object names.

ACCOUNT	CACHE_INSTANCES	CONSTRAINT*	DEGREE
ACTIVATE	CANCEL	CONSTRAINTS*	DEREF
ADMIN	CASCADE*	CONTENTS	DIRECTORY
AFTER	CAST	CONTINUE*	DISABLE
ALLOCATE*	CFILE	CONTROLFILE	DISCONNECT
ALL_ROWS	CHAINED	CONVERT*	DISMOUNT
ANALYZE	CHANGE	COST	DISTRIBUTED
ARCHIVE	CHARACTER*	COUNT*	DML
ARCHIVELOG	CHAR_CS	CPU_PER_CALL	DOUBLE*
ARRAY	CHECKPOINT	CPU_PER_SESSION	DUMP
AT*	CHOOSE	CURRENT_SCHEMA
AUTHENTICATED	CHUNK	CURRENT_USER*	EACH
AUTHORIZATION	CLEAR	CURSOR*	ENABLE
AUTOEXTEND	CLOB	CYCLE	END*
AUTOMATIC	CLONE		ENFORCE
	CLOSE*	DANGLING	ENTRY
BACKUP	CLOSED_CACHED_OPEN_ CURSORS	DATABASE	ESCAPE*
BECOME	COALESCE*	DATAFILE	ESTIMATE
BEFORE	COLUMNS	DATAFILES	EVENTS
BEGIN*	COMMIT*	DATAOBJNO	EXEMPT*
BFILE	COMMITTED	DBA	EXCEPTIONS
BITMAP	COMPATIBILITY	DEALLOCATE*	EXCHANGE
BLOB	COMPILE	DEBUG	EXCLUDING
BLOCK	COMPLETE	DEC*	EXECUTE*
BODY	COMPOSITE_LIMIT	DECLARE*	EXPIRE
	COMPUTE	DEFERRABLE	EXPLAIN
CACHE	CONNECT_TIME	DEFERRED	EXTENT
EXTENTS	INDEXES	MANAGE	NLS_CALENDAR
EXTERNALLY	INDICATOR*	MASTER	NLS_CHARACTERSET
	IND_PARTITION	MAX*	NLS_ISO_CURRENCY
FAILED_LOGIN_ATTEMPTS	INITIALLY	MAXARCHLOGS	NLS_LANGUAGE
FALSE	INITRANS	MAXDATAFILES	NLS_NUMERIC_ CHARACTERS
FAST	INSTANCE	MAXINSTANCES	NLS_SORT
FIRST_ROWS	INSTANCES	MAXLOGFILES	NOS_SPECIAL_CHARS
FLAGGER	INSTEAD	MAXLOGHISTORY	NLS_TERRITORY
FLUSH	INT*	MAXLOGMEMBERS	NOARCHIVELOG
FORCE	INTERMEDIATE	MAXSIZE	NOCACHE
FOREIGN*	ISOLATION*	MAXTRANS	NOCYCLE
FREELIST	ISOLATION_LEVEL	MAXVALUE	NOFORCE
FREELISTS		MEMBER	NOLOGGING
FULL	KEEP	MIN*	NOMAXVALUE
FUNCTION	KEY*	MINEXTENTS	NOMINVALUE
	KILL	MINIMUM	NONE
GLOBAL*		MINVALUE	NOORDER
GLOBALLY	LAYER	MOUNT	NOOVERIDE
GLOBAL_NAME	LESS	MOVE	NOPARALLEL
GROUPS	LIBRARY	MTS_DISPATCHERS	NORESETLOGS
HASH	LIMIT	MULTISET	NOREVERSE
HASHKEYS	LINK		NORMAL
HEADER	LIST	NATIONAL*	NOSORT
INSTANCE	LOB	NCHAR*	NOTHING
HEAP	LOCAL*	NCHAR_CS	NUMERIC*
	LOG	NCLOB	NVARCHAR2
IDLE_TIME	LOGFILE	NEEDED	OBJECT
IF	LOGGING	NESTED	OBJNO
INCLUDING	LOGICAL_READS_PER_CALL	NEW	OBJNO_REUSE
INDEXED	LOGICAL_READS_PER_ SESSION	NEXT*	OFF
OID	PLSQL_DEBUG	RESIZE	SHARED_POOL
OIDINDEX	POST_TRANSACTION	RESTRICTED	SHRINK
OLD	PRECISION*	RETURN	SKIM_UNUSABLE_INDEXES
ONLY*	PRESERVE*	RETURNING	SNAPSHOT
OPCODE	PRIMARY*	REUSE	SOME*
OPEN*	PRIVATE	REVERSE	SORT
OPTIMAL	PRIVATE_SGA	ROLE	SPECIFICATION
OPTIMIZER_GOAL	PRIVILEGE	ROLES	SPLIT
ORGANIZATION	PROCEDURE*	ROLLBACK*	SQLCODE*
OVERFLOW	PROFILE	ROWLABEL	SQLERROR*
OWN	PURGE	RULE	SQL_TRACE
			STANDBY
PACKAGE	QUEUE	SAMPLE	STATEMENT_ID
PARALLEL	QUOTA	SAVEPOINT	STATISTICS
PARTITION		SCAN_INSTANCES	STOP
PASSWORD	RANGE	SCHEMA*	STORAGE
PASSWORD_GRACE_TIME	RBA	SCN	STORE
PASSWORD_LIFE_TIME	READ*	SCOPE	STRUCTURE
PASSWORD_LOCK_TIME	REAL*	SD_ALL	SUM*
PASSWORD_REUSE_MAX	REBUILD	SD_INHIBIT	SWITCH
PASSWORD_REUSE_TIME	RECOVER	SD_SHOW	SYSDBA
PASSWORD_VERIFY_ FUNCTION	RECOVERABLE	SEGMENT	SYSOPER
PCTINCREASE	RECOVERY	SEG_BLOCK	SYSTEM
PCTTHRESHOLD	REF	SEG_FILE
PCTUSED	REFERENCES*	SEQUENCE	TABLES
PCTVERSION	REFERENCING	SERIALIZABLE	TABLESPACE
PERCENT	REFRESH	SESSIONS_PER_USER	TABLESPACE_NO
PERMANENT	REPLACE	SESSION_CACHED_ CURSORS	TABNO
PLAN	RESET	SHARED	TEMPORARY*
	RESETLOGS
THAN	TRUE	UNLOCK	VALIDATION
THE	TRUNCATE	UNRECOVERABLE	VALUE
THREAD	TX	UNTIL*	VARRAY
TIME	TYPE	UNUSABLE	VARYING*
TIMESTAMP		UNUSED	WHEN
TOPLEVEL	UBA	UPDATABLE	WITHOUT
TRACE	UNARCHIVED	USAGE*	WORK*
TRACING	UNDER	USE	WRITE*
TRANSACTION*	UNDO	USING*
TRANSITIONAL	UNLIMITED		XID
TRIGGERS

---

---

Copyright © 1997 Oracle Corporation. All Rights Reserved.