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 |
TNS-12234: TNS:Redirect to destination
ORA-02380: profile string does not exist
QSM-01014: top level operator in WHERE clause of the query is an OR
ORA-13838: invalid ADDRESS value
NNL-00565: set trace_file_name [<filename>] [<server_list>] : set|show the server's trace file name
IMG-00871: unexpected number of seeds
SQL*Loader-00275: Data is in control file but "INFILE *" has not been specified.
ORA-01515: error dropping log group string: no such log
ORA-29397: cannot grant/revoke switch privilege for string
ORA-32301: object-relational materialized views must be primary key based
ORA-02228: duplicate SIZE specification
NNO-00052: invalid domain description list