ora-01789:query block has incorrect number of result columns
来源:互联网 发布:name域名 编辑:程序博客网 时间:2024/06/09 16:14
author:skate
time:2009-06-11
由于自动管理分区的过程速度慢,所以今天在调整自动管理分区的过程时,遇到下面的这个错误
ora-01789:query block has incorrect number of result columns
goole之后,发现
这种问题一般出现在用UNION将若干个select连接到一起,由于select后的列的个数不相等而造成的。
比如
select userid from usercustom
union
select userid,loginname from usercustom
就会报这种错误。
---end---
- ora-01789:query block has incorrect number of result columns
- ora-01789:query block has incorrect number of result columns
- ORA-01789:query block has incorrect number of result columns
- ORA-01789: query block has incorrect number of result columns
- Caused exception message is: ORA-01789: query block has incorrect number of result columns
- ora-01789:query block has incorrect number of result columns 错误
- Caused exception message is: ORA-01789: query block has incorrect number of result columns
- 解决java.sql.SQLException: ORA-01789: query block has incorrect number of result columns
- Caused exception message is: ORA-01789: query block has incorrect number of result columns
- ORA-27063: number of bytes read/written is incorrect
- Oracle 12C ORA-01792: maximum number of columns in a table or view is 1000
- Incorrect number of FETCH variables
- ORA-27063: number of bytes read/written is incorrect之二
- Incorrect number of tokens found parsing file
- 【SQL0001】Query from the result of another query
- ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
- ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index SYS
- The used SELECT statements have a different number of columns
- window.showModalDialog以及window.open用法简介
- 11.3 跟踪网络传输状态
- 随便写写
- 11.5 在IE中使用Firebug
- 面试题:编程题,写一个Singleton出来。
- ora-01789:query block has incorrect number of result columns
- 234
- 通过jdbc调用存储过程
- 11.6 调试技巧
- 专业的计划书模板
- 11.7 小结
- wsdl -axis-webservise
- 467
- 有关JNLP中传SESSIONID为参数的问题