All Rows deleted from Table even when Column is missing in Sub-query.
(Doc ID 2496649.1)
Last updated on JANUARY 28, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
DELETE FROM tab1 WHERE col1 IN (SELECT col1 FROM tab2) has deleted all rows from tab1 even when col1 is missing in tab2 as wrong results without ORA-00904: "TAB2"."COL1": invalid identifier
This is a concern about whether or not a delete statement should behave when the "where" clause conditions are not fulfilled.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document