如何解决 Oracle 错误 ORA-01790?
我有两个由union"连接的选择语句.在执行该语句时，我得到了:
I have two select statements joined by "union". While executing that statement I've got:
错误报告:SQL 错误:ORA-01790:表达式必须与相应的表达式具有相同的数据类型01790. 00000 - 表达式必须与相应的表达式具有相同的数据类型"
Error report: SQL Error: ORA-01790: expression must have same datatype as corresponding expression 01790. 00000 - "expression must have same datatype as corresponding expression"
也许你能给我一个关于如何诊断这个问题的建议?
Maybe you can give me an advise on how to diagnose this problem?
推荐答案
正如我在问题中提到的，我想获得有关如何解决我的问题的建议.我所做的是在每个 select 语句中一次启用一列，并发现我的 SQL UNION 的最后一列不匹配.非常感谢您的参与和帮助，但我知道我的类型不匹配，我不知道如何进行故障排除.
As I mention in the question I'd like to have SUGGESTIONS for how to troubleshoot my problem. What I've done is enabled one column at a time in each select statement and found that I had mismatch at the very last column of my SQL UNION. Thanks a lot for participating and helping me, but I knew I had type mismatch, WHAT I didn't know is how to troubleshoot.
相关文章