title: how to run the triggers on the uncommitted data in pl sql
body: <p>There is a number range defined in my database table.(1000-1999),(from = 1000, to = 1999)
  I am trying to split this number range as two part below:</p>
  
  <pre><code>part1 : 1000-1001
  part2 : 1002-1999
  </code></pre>
  
  <p>There is a uniqueness check(trigger checks intersection of the number ranges after insertion to the database table.) in the DB so I should provide the appropriate data in order to perform this execution.</p>
  
  <p>Executed scripts are below for split operation :</p>
  
  <pre><code>UPDATE 1000-1999 as 1000-1001
  INSERT 1002-1999
  COMMIT;
  </code></pre>
  
  <p>While executing the above pl sql blocks, INSERT operation has been caught by trigger which runs on the database table.</p>
  
  <p>Why the trigger is running although I have updated the existing row before insert operation?</p>
  
  <p>How can we handle this situation?</p>