title: Oracle before insert all trigger
body: <p>I want to create a trigger before when insert into more rows.
  Before inserting the new data, i want to delete the earlier version of those by an id.</p>
  
  <p>e.g.:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER mytableTrigger
  BEFORE INSERT ALL ON mytable
  BEGIN
      DELETE FROM mytable WHERE column2 = fooId; --I want to get fooId in here.
  END;
  
  INSERT ALL
    INTO mytable (column1, column2, column3) VALUES (Seq.nextval(), fooId, 'val1.3')
    INTO mytable (column1, column2, column3) VALUES (Seq.nextval(), fooId, 'val2.3')
    INTO mytable (column1, column2, column3) VALUES (Seq.nextval(), fooId, 'val3.3')
  SELECT * FROM dual;
  </code></pre>
  
  <p>If it would be a simple row-level trigger then I can get fooId with :new.fooId.
  But it isn't.
  So, can i get or give an id to INSERT ALL Trigger?</p>
  
  <p>THX.</p>