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
- 2970 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-02165: invalid option for CREATE DATABASE
O2F-00332: A database link may not appear in the name of a user-defined type
ORA-02185: a token other than WORK follows COMMIT
ORA-09888: osnTXtt: txipc channel creation failed
ORA-12712: new character set must be a superset of old character set
ORA-14288: index is not partitioned by Composite Range method
ORA-13370: failure in applying 3D LRS functions
PCB-00235: Table size mismatch in INTO/USING. Minimum is: number
ORA-38484: FUNCTION/PACKAGE/TYPE string does not exist
TNS-12543: TNS:destination host unreachable
ORA-09854: snyPortInfo: bad return code from request.
ORA-19200: Invalid column specification
Oracle Errors 
