oracle关键字

误用oracle关键字

使用ssh测试的时候发现无法自动生成数据库表结构，日志抛出：

 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: create table g_gamebaseinfo (id number(19,0) not null, click_num number(10,0), comments_num number(10,0), comments_score number(10,0), desc varchar2(255 char), game_id varchar2(255 char), game_kind number(10,0), game_name varchar2(255 char) not null unique, game_type varchar2(255 char), level number(10,0), logo varchar2(255 char), place varchar2(255 char), start_time timestamp, status number(10,0), total_score number(10,0), verify_time timestamp, primary key (id))
 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - ORA-00904: : 标识符无效


检查发现有一个desc字段和oracle关键字冲突。以后编写代码的时候一定要注意避免使用了数据库的关键字。

oracle的保留字

ACCESS ADD ALL ALTER AND ANY 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 MLSLABEL MODE MODIFY

NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER

OF OFFLINE ON ONLINE OPTION OR ORDER

PCTFREE PRIOR　PRIVILEGES PUBLIC

RAW RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS

SELECT SESSION SET　SHARE SIZE SMALLINT START SUCCESSFUL SYNONYM SYSDATE

TABLE THEN TO TRIGGER

UID UNION UNIQUE　UPDATE USER

VALIDATE VALUES VARCHAR VARCHAR2 VIEW WHENEVER

WHERE WITH