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
- 3062 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 |
RMAN-06909: WARNING: parallelism require Enterprise Edition
ORA-30100: internal error [number]
ORA-25291: Buffer does not exist for the specified queue
PCB-00303: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL
ORA-37073: (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
ORA-06771: TLI Driver: error reading version
ORA-27125: unable to create shared memory segment
ORA-38718: Invalid thread number specified in the DUMP FLASHBACK command.
ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported
NNL-00981: Timeouts, server not responding: number
ORA-01463: cannot modify column datatype with current constraint(s)
Oracle Errors 
