关键字是指在数据库中有意义的字，通常是数据库内部使用， 不能用于命名用户的数据对象。 有的数据库还会详细划分，例如分为关键字，候选字，甚至更详细的分类。分类的标准例如有的是绝对不可以使用，有的通过一定手段例如添加双引号可以使用。

我们为了方便统一称之为关键字，通常用户编写的对象中使用关键字会造成错误或不确定的影响，为了避免这个问题，用户应该避免使用数据库的关键字(含保留字或其他保留别名等)。

这个系列主要整理了各大数据库的关键字，可以用于建库，建表，写存储过程，函数等场景避免冲突。最后会有个脚本工具用来检查是否使用关键字。9de7bb31d0644e7393039222babfed10

欢迎收藏。

Oracle

Oracle保留字：

由Oracle保留,他们对oracle有着特殊的意义，因此无法重新定义。因此，不能使用它们来命名数据库对象，例如列、表或索引

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

Oracle关键字

以下词语对甲骨文也有特殊意义，但不是保留词，因此可以重新定义。然而，有些可能最终成为保留字

ADMIN AFTER ALLOCATE ANALYZE ARCHIVE ARCHIVELOG AUTHORIZATION AVG BACKUP BEGIN BECOME BEFORE BLOCK BODY CACHE CANCEL CASCADE CHANGE CHARACTER CHECKPOINT CLOSE COBOL COMMIT COMPILE CONSTRAINT CONSTRAINTS CONTENTS CONTINUE CONTROLFILE COUNT PROFILE QUOTA READ REAL RECOVER REFERENCES REFERENCING RESETLOGS RESTRICTED REUSE ROLE ROLES ROLLBACK CURSOR CYCLE DATABASE DATAFILE DBA DEC DECLARE DISABLE DISMOUNT DOUBLE DUMP EACH ENABLE END ESCAPE EVENTS EXCEPT EXCEPTIONS EXEC EXPLAIN EXECUTE EXTENT EXTERNALLY FETCH FLUSH FREELIST FREELISTS FORCE FOREIGN FORTRAN SAVEPOINT SCHEMA SCN SECTION SEGMENT SEQUENCE SHARED SNAPSHOT SOME SORT SQL SQLCODE SQLERROR FOUND FUNCTION GO GOTO GROUPS INCLUDING INDICATOR INITRANS INSTANCE INT KEY LANGUAGE LAYER LINK LISTS LOGFILE MANAGE MANUAL MAX MAXDATAFILES MAXINSTANCES MAXLOGFILES MAXLOGHISTORY MAXLOGMEMBERS MAXTRANS MAXVALUE MIN MINEXTENTS MINVALUE MODULE SQLSTATE STATEMENT_ID STATISTICS STOP STORAGE SUM SWITCH SYSTEM TABLES TABLESPACE TEMPORARY THREAD TIME MOUNT NEXT NEW NOARCHIVELOG NOCACHE NOCYCLE NOMAXVALUE NOMINVALUE NONE NOORDER NORESETLOGS NORMAL NOSORT NUMERIC OFF OLD ONLY OPEN OPTIMAL OWN PACKAGE PARALLEL PCTINCREASE PCTUSED PLAN PLI PRECISION PRIMARY PRIVATE PROCEDURE TRACING TRANSACTION TRIGGERS TRUNCATE UNDER UNLIMITED UNTIL USE USING WHEN WRITE WORK

PL/SQL保留字

当在嵌入式SQL语句中使用以下PL/SQL关键字时，可能需要特殊处理

ABORT ACCEPT ACCESS ADD ALL ALTER AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASSIGN AT AUTHORIZATION AVG BASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN BY CASE CHAR_BASE CHAR CHECK CLOSE CLUSTER CLUSTERS COLAUTH COLUMNS COMMIT COMPRESS CONNECT CONSTANT COUNT CRASH CREATE CURRENT CURRVAL CURSOR DATA_BASE DATABASE DATE DBA DEBUGOFF DEBUGON DECLARE DEFAULT DEFINITION DELAY DELETE DELTA DESC DIGITS DISPOSE DISTINCT DO DROP ELSE ELSIF END ENTRY EXCEPTION_INIT EXCEPTION EXISTS EXIT FALSE FETCH FLOAT FOR FORM FROM FUNCTION GENERIC GOTO GRANT GROUP HAVING IDENTIFIED IF IN INDEX INDEXES INDICATOR INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LIMITED LOOP MAX MIN MINUS MLSLABEL MOD MODE NATURAL NEW NEXTVAL NOCOMPRESS NOT NULL NUMBER_BASE NUMBER OF ON OPEN OPTION OR ORDER OTHERS OUT PACKAGE PARTITION PCTFREE POSITIVE PRAGMA PRIOR PRIVATE PROCEDURE PUBLIC RAISE RANGE REAL RECORD RELEASE REMR RENAME RESOURCE RETURN REVERSE REVOKE ROLLBACK ROWID ROWLABEL ROWNUM ROWTYPE RUN SAVEPOINT SCHEMA SEPARATE SET SIZE SMALLINT SELECT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUM TABAUTH TABLE TABLES TASK TERMINATE THEN TO TRUE TYPE UNION UNIQUE UPDATE USE VALUES VARCHAR VARCHAR2 VARIANCE VIEW VIEWS WHEN WHERE WHILE WITH WORK XOR

Oracle保留命名空间

包含Oracle保留的命名空间列表。Oracle库中函数名的初始字符仅限于此列表中的字符串。由于潜在的名称冲突，请使用不以这些字符开头的函数名。例如，SQL*Net透明网络服务函数都以字符“NS”开头，因此您需要避免命名以“NS”开始的函数

O: OCI函数 , S: 函数名来自 SQLLIB and system-dependent libraries , XA: XA应用专用的外部函数 , GEN KP L NA NC ND NL NM NR NS NT NZ TTC UPI: 内部函数