PLS-00326: IN clause must contain same number of expressions
as subquery



PLS-00326: IN clause must contain same number of expressions as subquery..

Answer / guest

Cause: The number of expressions in an IN clause did not
equal the number of expressions in a corresponding subquery
select list. For example, the following statement is invalid
because the IN clause contains two expressions, but the
subquery select list contains just one: ... WHERE (ename,
sal) IN (SELECT sal FROM emp);

Action: Check the number of expressions in each set, then
revise the statement to make the numbers equal.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39060: table(s) dropped because of conflict with master table

1 Answers  


ORA-08195: Flashback Table operation is not supported on partitions

1 Answers  


TNS-00293: Trace File Name : string

1 Answers  


ORA-16131: An error occurred during a Terminal Recovery of the standby.

1 Answers  


ORA-31205: DBMS_LDAP: PL/SQL - Invalid LDAP Auth method.

1 Answers  






ORA-19038: Invalid opertions on query context

1 Answers  


TNS-12665: NLS string open failed

1 Answers  


ORA-22953: Cardinality of the input to powermultiset exceeds maximum allowed

1 Answers  


ORA-23306: schema string does not exist

1 Answers  


NNO-00072: loading from region database

1 Answers  


DRG-51100: invalid program argument index

1 Answers  


ORA-08231: smscre: unable to attach to SGA

1 Answers  


Categories