Oracle8 SQL Reference Release 8.0 A58225-01 |
Library | Product | Contents | Index

# C
Oracle Reserved Words and Keywords

This appendix lists Oracle reserved words and keywords.

Table C-1, "Reserved Words" 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*

Table C-2, " Keywords" 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 |  |  |

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