We have a transaction where are making a series of delete and Insert.
Here I am checking whether the record is deleted or not.
If the record is deleted I want to insert the data.
Since this is a in a transaction the physical delete is not happening.
Here my running a select query to read the data from the database (Oracle)
My logic always goes to update since physical delete is not made.