ORA-01790: expression must have same datatype as corresponding expression
问题前提:在一次日常开发中,使用UNION,UNION ALL 关联表插入数据时,报如下错误。
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
表结构
create
原创
2022-02-18 17:48:10 ·
3906 阅读 ·
0 评论