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
- 2951 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-38774: cannot disable media recovery - flashback database is enabled
CLSR-00512: Invalid CAA trigger event type [string]
ORA-31093: null or invalid value specified for parameter : string
PCC-02013: unknown escape sequence
TNS-04068: Cannot start an Oracle Connection Manager instance remotely.
ORA-12470: NULL or invalid user label: string
ORA-27074: unable to determine limit for open files
SQL-02128: Sessions still exist, not logged off
ORA-24812: character set conversion to or from UCS2 failed
ORA-02332: cannot create index on attributes of this column
LSX-00018: invalid schema context
ORA-02399: exceeded maximum connect time, you are being logged off
Oracle Errors 
