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
- 2875 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 |
ORA-31038: Invalid string value: "string"
PLS-00457: expressions have to be of SQL types
ORA-32319: Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
ORA-29868: cannot issue DDL on a domain index marked as LOADING
ORA-12727: invalid back reference in regular expression
NNL-00896: Requests refused, modifications disabled: number
ORA-07500: scglaa: $cantim unexpected return
ORA-13710: Parameter "string" must have a higher value than parameter "string". The values supplied were "string" and "string" respectively.
RMAN-04022: target database mount id string does not match channel's mount id string
ORA-06747: TLI Driver: error in listen
RMAN-02004: quoted string too big
ORA-27069: attempt to do I/O beyond the range of the file
Oracle Errors 
