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 |
ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
ORA-16702: generic resource manager warning
ORA-01870: the intervals or datetimes are not mutually comparable
ORA-12657: No algorithms installed
ORA-16068: redo log file activation identifier mismatch
ORA-15125: ASM file name 'string' contains an invalid template name
ORA-39130: Object type string not imported. Base object name conflicts with the master table
ORA-00363: log is not the archived version
ORA-19605: input filename must be specified
ORA-13403: invalid rasterDataTable specification
IMP-00011: formatted table data not currently supported
KUP-04040: file string in string not found