Top / DB関連 / Oracleの予約語

Oracleの予約語 †

A 

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
 

B 

BACKUP BECOME BEFORE BEGIN BETWEEN BFILE BITMAP BLOB
BLOCK BODY BY
 

C 

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 CURREN_USER
CURSOR CYCLE
 

D 

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
 

E 

EACH ELSE ENABLE END ENFORCE ENTRY ESCAPE EXCEPT 
EXCEPTIONS EXCHANGE EXCLUDING EXCLUSIVE EXECUTE 
EXISTS EXPIRE EXPLAIN EXTENT EXTENTS EXTERNALLY
 

F 

FAILED_LOGIN_ATTEMPTS FALSE FAST FILE FIRST_ROWS 
FLAGGER FLOAT FLOB FLUSH FOR FORCE FOREIGN FREELIST 
FREELISTS FROM FULL FUNCTION
 

G 

GLOBAL GLOBALLY GLOBAL_NAME GRANT GROUP GROUPS
 

H 

HASH HASHKEYS HAVING HEADER HEAP
 

I 

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
 

J

 

K 

KEEP KEY KILL
 

L 

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
 

M 

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
 

N 

NATIONAL NCHAR NCHAR_CS NCLOB NEEDED NESTED 
NETWORK NEW NEXT NOARCHIVELOG NOAUDIT NOCACHE 
NOCOMPRESS NOCYCLE NOFORCE NOLOGGING NOMAXVALUE 
NOMINVALUE NONE NOORDER NOOVERRIDE NOPARALLEL 
NOPARALLEL NOREVERSE NORMAL NOSORT NOT NOTHING 
NOWAIT NULL NUMBER NUMERIC NVARCHAR2
 

O 

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
 

P 

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
 

Q 

QUEUE QUOTA
 

R 

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
 

S 

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
 

T 

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
 

U 

UB2 UBA UID UNARCHIVED UNDO UNION UNIQUE 
UNLIMITED UNLOCK UNRECOVERABLE UNTIL UNUSABLE 
UNUSED UPDATABLE UPDATE USAGE USE USER 
USING
 

V 

VALIDATE VALIDATION VALUE VALUES VARCHAR 
VARCHAR2 VARYING VIEW
 

W 

WHEN WHENEVER WHERE WITH WITHOUT WORK 
WRITE WRITEDOWN WRITEUP
 

X 

XID
 

Y 

YEAR
 

Z 

ZONE
↑

参考文献 †

最新の10件
2010-07-09 2010-07-08 2010-07-07 2010-06-29 2010-06-28
人気の20件
Counter: 509, today: 1, yesterday: 0