Re: delete with the "in ()" clause and NULL
Posted by:
Wim Roffel
Date: September 06, 2020 09:23AM
SO if I understand it right if I do the following two command the records with NULL values will not be deleted:
DELETE FROM mytable WHERE myfield IN (1,2,3)
DELETE FROM mytable WHERE myfield NOT IN (1,2,3)
Subject
Written By
Posted
September 03, 2020 05:06AM
September 03, 2020 09:54AM
Re: delete with the "in ()" clause and NULL
September 06, 2020 09:23AM
September 06, 2020 11:23AM
September 25, 2020 05:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.