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
- 2871 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 |
DRG-11123: theme indexing is not supported
RMAN-06071: could not open datafile string
ORA-01944: IDENTIFIED EXTERNALLY already specified
LPX-00275: can't set output/data encoding AFTER parsing
PCC-02013: unknown escape sequence
ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor
QSM-00752: the parameter string contains an invalid combination of options string
TNS-12500: TNS:listener failed to start a dedicated server process
ORA-16574: switchover disallowed when required databases are offline
KUP-04023: field start is after end of record
EXP-00064: %s is an inner nested table and cannot be exported.
DRG-50908: invalid maximum number of documents string
Oracle Errors 
