How to fix the Oracle error PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column?

In this post, you’ll learn more about the Oracle ErrorPLS-00319: subquery in an IN or NOT IN clause must contain exactly one column with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column ?

You can fix this error in Oracle by following the below steps

Change the subquery to select only one column.