Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00319: subquery in an IN or NOT IN clause must contain
exactly one column
- 1 Answers
- 3058 Views
- I also Faced
- E-Mail Answers
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 |
AMD-00152: Workspace "string" is not currently open.
SQL*Loader-00487: COUNT clause required for collection string
ORA-06563: top level procedure/function specified, cannot have subparts
SQL*Loader-00561: end of file
NNO-00604: disabling all request processing
ORA-08231: smscre: unable to attach to SGA
ORA-28651: Primary index on IOTs can not be marked unusable
ORA-00001: unique constraint (string.string) violated
DGM-16948: Can not proceed to switchover. Primary is still "string".
ORA-12234: TNS:Redirect to destination
ORA-23536: the object "string"."string" is not cached at the middle tier as expected.
ORA-26019: Column string in table string of type string not supported by direct path
Oracle Errors 
