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


PLS-00319: subquery in an IN or NOT IN clause must contain
exactly one column



PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column..

Answer / guest

Cause: An invalid expression such as X IN (SELECT A,B ...)
was used. When a [NOT]IN clause is used with a subquery, it
does not test for set membership. The number of expressions
in the [NOT]IN clause and the subquery select list must
match. So, in the example above, the subquery must specify
at most one column.

Action: Change the subquery to select only one column.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02433: cannot disable primary key - primary key not defined for table

1 Answers  


NNO-00604: disabling all request processing

1 Answers  


ORA-30352: inconsistent numeric precision or string length

1 Answers  


ORA-13345: a compound polygon geometry has fewer than five coordinates

1 Answers  


ORA-12689: Server Authentication required, but not supported

1 Answers  






TNS-12642: No session key

1 Answers  


QSM-01017: aggregate argument cannot be converted to canonical form

1 Answers  


ORA-27122: unable to protect memory

1 Answers  


ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out

1 Answers  


ORA-19000: missing RELATIONAL keyword

1 Answers  


TNS-00120: Missing PUMPS in INTCHG.ORA

1 Answers  


ORA-07589: spdde: system ID not set

1 Answers  






Categories