PLS-00319: subquery in an IN or NOT IN clause must contain
exactly one column
- 1 Answers
- 2524 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 |
QSM-01080: invalid dimension, string
ORA-10638: Index status is invalid
TNS-00246: Connection Manager: Failed to start tracing
ORA-08179: concurrency check failed
TNS-01442: No filtering rules currently in effect.
ORA-01859: a non-alphabetic character was found where an alphabetic was expected
LCD-00201: could not open specified filename [string]
ORA-13865: Module name must be specified
ORA-36270: (XSCGMDLAGG03) The right-hand side of the AGGREGATION function includes duplicate values.
ORA-13039: failed to update spatial index for element string.string.string
ORA-19809: limit exceeded for recovery files
ORA-27418: syntax error in repeat interval
Oracle Errors 
