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

PLS-00550: character set specification is not allowed for this type

1 Answers  


ORA-30731: scope constraint not allowed on nested table column when the nested table is being created

1 Answers  


ORA-29878: warning in the execution of ODCIINDEXTRUNCATE routine

1 Answers  


SQL*Loader-00131: Invalid multithreading option

1 Answers  


ORA-30509: client logoff triggers cannot have AFTER type

1 Answers  






ORA-26094: stream format error: input column overflow

0 Answers   HP,


PCB-00229: Indicator variable "string" has wrong type or length

1 Answers  


LPX-00106: attribute "~1S" of element "~2S" is undefined

1 Answers  


LFI-00137: Unable to perform string on a file object that is string.

1 Answers  


DRG-50860: failed to prepare statement

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  


Categories