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

TNS-12234: TNS:Redirect to destination

1 Answers  


ORA-02380: profile string does not exist

1 Answers  


QSM-01014: top level operator in WHERE clause of the query is an OR

1 Answers  


ORA-13838: invalid ADDRESS value

1 Answers  


NNL-00565: set trace_file_name [<filename>] [<server_list>] : set|show the server's trace file name

1 Answers  






IMG-00871: unexpected number of seeds

1 Answers  


SQL*Loader-00275: Data is in control file but "INFILE *" has not been specified.

1 Answers  


ORA-01515: error dropping log group string: no such log

1 Answers  


ORA-29397: cannot grant/revoke switch privilege for string

1 Answers  


ORA-32301: object-relational materialized views must be primary key based

1 Answers  


ORA-02228: duplicate SIZE specification

1 Answers  


NNO-00052: invalid domain description list

1 Answers  


Categories