如何解决Oracle错误ORA-01790? [英] How to resolve Oracle error ORA-01790?

问题描述

我有两个由"union"连接的select语句.在执行该语句时，我得到了:

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屋！