如何解决 Oracle 错误 ORA-01790? [英] How to resolve Oracle error 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.

这篇关于如何解决 Oracle 错误 ORA-01790?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！