Oracle Server Reserved Words
Oracle Server Reserved Words[1]
The list on Oracle's web site is not exhaustive. The definitive reference is Oracle SQL Developer. When a word in it turns blue, that is a reserved word.
ACCESS ACCOUNT ACTIVATE ADD ADMIN ADVISE AFTER ALIAS ALL ALLOCATE ALL_ROWS 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 CHARACTER CHAR_CS CHECK CHECKPOINT CHOOSE CHUNK CLEAR CLOB CLONE CLOSE CLOSE_CACHED_OPEN_CURSORS CLUSTER COALESCE COLUMN COLUMNS COLUMN_VALUE COMMENT COMMIT COMMITTED COMPATIBILITY COMPILE COMPLETE COMPOSITE_LIMIT COMPRESS COMPUTE CONNECT CONNECT_TIME CONSTRAINT CONSTRAINTS CONTENTS CONTINUE CONTROLFILE CONVERT COST COUNT CPU_PER_CALL CPU_PER_SESSION CREATE CURRENT CURRENT_SCHEMA CURREN_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 DESCRIPTION DIRECTORY DISABLE DISCONNECT DISMOUNT DISTINCT DISTRIBUTED DML DOUBLE DROP DUMP DURATION EACH ELSE ENABLE END ENFORCE ENTRY ESCAPE 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 MASK MASTER MAX MAXARCHLOGS MAXDATAFILES MAXEXTENTS MAXINSTANCES MAXLOGFILES MAXLOGHISTORY MAXLOGMEMBERS MAXSIZE MAXTRANS MAXVALUE MEMBER MIN MINEXTENTS MINIMUM MINUS MINVALUE MLSLABEL MLS_LABEL_FORMAT MODE MODIFY MOUNT MOVE MTS_DISPATCHERS MULTISET NATIONAL NCHAR NCHAR_CS NCLOB NEEDED NESTED NESTED_TABLE_ID NETWORK NEW NEXT NOARCHIVELOG NOAUDIT NOCACHE NOCOMPRESS NOCYCLE NOFORCE NOLOGGING NOMAXVALUE NOMINVALUE NONE NOORDER NOOVERRIDE NOPARALLEL NOREVERSE NORMAL NOSORT NOT NOTHING NOTIFICATION 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 OWNER 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 PERIOD PERMANENT PLAN PLSQL_DEBUG POST_TRANSACTION PRECISION PRESERVE PRIMARY PRIOR PRIORITY 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 ROOT 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 SESSIONS_PER_USER SESSION_CACHED_CURSORS SET SHARE SHARED SHARED_POOL SHRINK SITE SIZE SKIP SKIP_UNUSABLE_INDEXES SMALLINT SNAPSHOT SOME SORT SPECIFICATION SPLIT SQL_TRACE STANDBY START STATEMENT_ID STATISTICS STOP STORAGE STORE STRUCTURE SUCCESSFUL SWITCH SYNONYM SYSDATE SYSDBA SYSOPER SYSTEM SYS_OP_ENFORCE_NOT_NULL$ SYS_OP_NTCIMG$ TABLE TABLES TABLESPACE TABLESPACE_NO TABNO TEMPORARY THAN THE THEN THREAD TIME TIMESTAMP 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 YEAR ZONE
Internal Links
Parent Article: Oracle Server (Notes)