Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-31643: unable to close dump file "string"

1 Answers  


RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

1 Answers  


ORA-14109: partition-extended object names may only be used with tables

1 Answers  


SQL*Loader-00433: no attributes found for column object string in table string

1 Answers  


ORA-32833: failure string trying to release administration lock

1 Answers  






ORA-02140: invalid tablespace name

1 Answers  


KUP-04078: invalid file name specified: string

1 Answers  


ORA-25407: connection terminated

1 Answers  


ORA-28008: invalid old password

1 Answers  


ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

1 Answers  


ORA-03221: Temporary tablespaces and temporary segments must have standard block size

1 Answers  


SQL*Loader-00562: record too big

1 Answers  






Categories