Error: ORA 947 Text: not enough values
------------------------------------------------------------------------------- Cause: This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer items than the first set.This can occur in a WHERE or HAVING clause in which a nested SELECT returns too few columns as in:
WHERE (A,B) IN (SELECT C FROM ...)
Another common cause of this error is an INSERT statement in which the VALUES or SELECT clause does not contain enough values needed for the INSERT, as in
INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')Action: Check the number of items in each set and change the SQL statement to
make them equal.
------------------------------------------------------------------------------- Cause: This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer items than the first set.This can occur in a WHERE or HAVING clause in which a nested SELECT returns too few columns as in:
WHERE (A,B) IN (SELECT C FROM ...)
Another common cause of this error is an INSERT statement in which the VALUES or SELECT clause does not contain enough values needed for the INSERT, as in
INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')Action: Check the number of items in each set and change the SQL statement to
make them equal.
解决方案 »
- ORACLE行列转换存储过程,如何转换成MSSQL? 急,在线等
- 关于数据插入方法的疑问
- 急 急!!!!失去的控制文件或损坏了
- 请高手指点触发器的条件判断语句
- ORACLE:INVALID_HANDLE 什么错误??
- oracle如何建立临时表(急)
- 请问在ASP中如何利用ORALE OBJECT FOR OLE调用存储过程?
- 如何去除当创建database link时oracle自动添加的US.ORACLE.COM后缀?
- 请教:从sql server2000导出数据到oracle8i,表名是大小写混写的,到oracle也是,所以出了问题。
- oracle8i里用PL/SQL对自定义的对象类型操作的问题,急!
- 高分求救 Oracle 网络问题、
- 初雪oracle开发,不知pl/sql在整个开发中的地位如何,重要吗?
-------------------------------------------------------把 对应字段的值对应列出来... :)