它要三个字段,而你只给两个字段ORA-00947 not enough valuesCause: 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 inINSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')
Action: Check the number of items in each set and change the SQL statement to make them equal.
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 inINSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')
Action: Check the number of items in each set and change the SQL statement to make them equal.
SELECT
?,
?,
?,
CAPITAL_TYPE,
CUST_ID,
CUST_TYPE,
TRADE_ACCTID,
CUST_FNAME,
BANK_ID,
BANK_NAME,
BANK_ACCTID,
BANK_ACCTNAME,
AGENCY_BANKID,
?,
?,
NULL,
CURRENCY_ID,
?,
NULL,
?,
?,
'0',
?,
NULL,
? FROM T_BALANCE WHERE TRIM(TRADE_ACCTID) = ? AND TRIM(CURRENCY_ID) = ? AND TRIM(TRUST_NETID) = ?谁用白话文解释一下这段insert,怎么和我平时接触的inserter不一样。