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 |
IMP-00015: following statement failed because the object already exists:
ORA-26516: no push transaction acknowledgement
ORA-03205: partition name is required when partitioned type is specified
PLS-00252: reference to the wrong copy of package STANDARD
ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported
RMAN-06439: RMAN must be upgraded to version string to work with this package
ORA-28664: a partitioned table may not be coalesced as a whole
DRG-12437: highlight table release failed
ORA-13460: GeoRaster metadata SRS error
ORA-23406: insufficient privileges on user "string"
ORA-15033: disk 'string' belongs to diskgroup "string"
DRG-11731: translation does not exist