Oracle数据库的关键字

水深无声 2022-08-08 11:49 199阅读 0赞

在Oracle数据库中有很多关键字，在建表时如果用这些关键字来作为字段的话会造成建表失败，有个解决方法就是在关键字上加上英文双引号（记住，不是单引号，MySQL里面关键字就用单引号，oracle不一样），接下来，我就列举一下Oracle数据库中的一些关键字（可能不是很全，希望读者补充）

Oracle 数据库关键字  
ALL\*       
ALTER\*     
 AND\*  
ANY\*  
ARRAY  
AS\*  
ASC\*  
AT  
AUTHID  
AVG  
BEGIN  
BETWEEN\*  
BINARY\_INTEGER  
BODY  
BOOLEAN  
BULK  
BY\*  
CHAR\*  
CHAR\_BASE  
CHECK\*  
CLOSE  
CLUSTER\*  
COLLECT  
COMMENT\*  
COMMIT  
COMPRESS\*  
CONNECT\*  
CONSTANT  
CREATE\*  
CURRENT\*  
CURRVAL  
CURSOR  
DATE\*  
DAY  
DECLARE  
DECIMAL\*  
DEFAULT\*  
DELETE\*  
DESC\*  
DISTINCT\*  
DO  
DROP\*  
ELSE\*  
ELSIF  
END  
EXCEPTION  
EXCLUSIVE\*  
EXECUTE  
EXISTS\*  
EXIT  
EXTENDS  
FALSE  
FETCH  
FLOAT\*  
FOR\*  
FORALL  
FROM\*  
FUNCTION  
GOTO  
GROUP\*  
HAVING\*  
HEAP  
HOUR  
IF  
IMMEDIATE\*  
IN\*  
INDEX\*  
INDICATOR  
INSERT\*  
INTEGER\*  
INTERFACE  
INTERSECT\*  
INTERVAL  
INTO\*  
IS\*  
ISOLATION  
JAVA  
LEVEL\*  
LIKE\*  
LIMITED  
LOCK\*  
LONG\*  
LOOP  
MAX  
MIN  
MINUS\*  
MINUTE  
MLSLABEL\*  
MOD  
MODE\*  
MONTH  
NATURAL  
NATURALN  
NEW  
NEXTVAL  
NOCOPY  
NOT\*  
NOWAIT\*  
NULL\*  
NUMBER\*  
NUMBER\_BASE  
OCIROWID  
OF\*  
ON\*  
OPAQUE  
OPEN  
OPERATOR  
OPTION\*  
OR\*  
ORDER\*  
ORGANIZATION  
OTHERS  
OUT  
PACKAGE  
PARTITION  
PCTFREE\*  
PLS\_INTEGER  
POSITIVE  
POSITIVEN  
PRAGMA  
PRIOR\*  
PRIVATE  
PROCEDURE  
PUBLIC\*  
RAISE  
RANGE  
RAW\*  
REAL  
RECORD  
REF  
RELEASE  
RETURN  
REVERSE  
ROLLBACK  
ROW\*  
ROWID\*  
ROWNUM\*  
ROWTYPE  
SAVEPOINT  
SECOND  
SELECT\*  
SEPARATE  
SET\*  
SHARE\*  
SMALLINT\*  
SPACE  
SQL  
SQLCODE  
SQLERRM  
START\*  
STDDEV  
SUBTYPE  
SUCCESSFUL\*  
SUM  
SYNONYM\*  
SYSDATE\*  
TABLE\*  
THEN\*  
TIME  
TIMESTAMP  
TO\*  
TRIGGER\*  
TRUE  
TYPE  
UID\*  
UNION\*  
UNIQUE\*  
UPDATE\*  
USE  
USER\*  
VALIDATE\*  
VALUES\*  
VARCHAR\*  
VARCHAR2\*  
VARIANCE  
VIEW\*  
WHEN  
WHENEVER\*  
WHERE\*  
WHILE  
WITH\*  
WORK  
WRITE  
YEAR  
ZONE