title: problem in instead of delete views in oracle
body: <p>I have a view as:</p>
  
  <pre><code>select * from ot.vw_rebellionrid;
  </code></pre>
  
  <p>which is showing me:</p>
  
  <p><a href="https://i.stack.imgur.com/8vAQu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8vAQu.png" alt="enter image description here"></a></p>
  
  <p><code>full_name</code> is column of <code>trainer</code> table
  <code>subject_name</code> is column of <code>subject</code> table</p>
  
  <p>The view has the query:</p>
  
  <pre><code>SELECT full_name, subject_name
       FROM ot.trainer, ot.subject;
  </code></pre>
  
  <p>So,I am learning the instead of delete tigger,so the code for instead of trigger is:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER ot.io_delete
  INSTEAD OF DELETE ON ot.vw_RebellionRid
  FOR EACH ROW
  BEGIN
    DELETE FROM ot.trainer WHERE FULL_NAME = :old.FULL_NAME;
    DELETE FROM ot.subject WHERE SUBJECT_NAME= :old.SUBJECT_NAME;
  END;
  /
  </code></pre>
  
  <p>So,to execute this trigger,I execute the following statement:</p>
  
  <pre><code>delete from ot.vw_RebellionRid where subject_name='java';
  </code></pre>
  
  <p>when it is executed,then :</p>
  
  <pre><code>2 rows deleted.
  </code></pre>
  
  <p>According to my understanding,Since the two rows has subject_name as java the remaining output,I think will be after the deletion:</p>
  
  <pre><code>--------------------------
  full_name | subject_ name |
  ---------------------------
  Manish Sharma Oracle      |
  ashwin        Oracle      |
  ---------------------------
  </code></pre>
  
  <p>But when I executed </p>
  
  <pre><code>select * from ot.vw_RebellionRid ;
  </code></pre>
  
  <p>then,I got the output as EMPTY TABLE;</p>
  
  <p><a href="https://i.stack.imgur.com/0r3Wg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0r3Wg.png" alt="enter image description here"></a></p>
  
  <p>Since,there were 4rows,2rows were deleted,but when i again select the view then how I am getting empty table?I should have got remaining two rows.</p>