ORA-01747: user.table.column, table.column 或列说明无效

不念不忘少年蓝@ 2022-05-24 10:18 167阅读 0赞

java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效  
这个出错的原因是因为表的列名称使用了Oracle声明的关键字。

## 一、Oracle声明的关键字 ##

可通过Oracle提供的V$RESERVED\_WORDS，查看关键字

select * from v$reserved_words ORDER BY KEYWORD ASC

查询结果：  
![这里写图片描述][70]  
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

## 二、解决方法 ##

1.如果对业务影响不大，还是将字段改成非关键字；  
2.对历史遗留系统的处理，考虑修改表的列名，风险较大。  
可通过修改特定查询语句！  
在查询列中使用**双引号**，要注意列的大小写

[70]: /images/20220524/baf98a65a4c74ca99d30166dd0cff36e.png