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

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

查询结果：

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.对历史遗留系统的处理，考虑修改表的列名，风险较大。
可通过修改特定查询语句！
在查询列中使用双引号，要注意列的大小写