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-00074: no process has been specified
PLS-00511: a record may not contain a PL/SQL table of records
ORA-00325: archived log for thread string, wrong thread # string in header
SQL*Loader-00918: The catalog must be loaded (as SYS) for SQL*Loader to be used
TNS-04205: Trace Assistant Internal ERROR: Memory
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
LRM-00119: unable to obtain a valid value for 'string'
ORA-17502: ksfdcre:string Failed to create file string
SQL*Loader-00710: Internal error: direct path stream buffer not loaded
ORA-16506: out of memory
ORA-10644: SYSTEM tablespace cannot be default temporary tablespace
ORA-30733: cannot specify rowid constraint on scoped ref column