title: Is there any way we can emulate the way of using :old and :new of row triggers in statement triggers in PL/SQL
body: <p>Good Day Buddies!</p>
  <p>So, here is my Question, it says -</p>
  <blockquote>
  <p>Write a update, delete trigger on clientmstr table. The System
  should keep track of the records that ARE BEING updated or
  deleted. The old value of updated or deleted records should be
  added in audit_trade table. (Separate implementation using both row
  and statement triggers)</p>
  </blockquote>
  <p>And my solution looks like this -</p>
  <pre><code>-- For row trigger
  create or replace trigger row_trigger
      before delete or update on client_master
      referencing old as old new as new
      for each row
  begin
      insert into audit_table values(
      :old.client_id, :old.client_name, :old.client_budget
      );
  end;
  /
  </code></pre>
  <hr />
  <p>And as per the question I have to implement the same using <strong>statement trigger</strong> but I couldn't think of a way it can be done. I studied about statement triggers and I learned that we can't use :old and :new here. <strong>Is there any way we can implement the same row trigger method of adding in audit table using statement trigger?</strong> I am just starting out and it's just been two days I started learning PL/SQL. I spend whole day searching everywhere on the internet - tried looking for an example but I am not getting it. Can anyone help?</p>
  <hr />
  <p><strong>Edit</strong></p>
  <p>(1) I am using Oracle SQL Developer</p>
  <p>(2) As someone suggested in comments - it isn't possible to do this in statement trigger, I think the same. I have to submit my assignment this Saturday. I had a conversation with my teacher - she said it's possible to implement it using statement trigger. I asked her how - but she didn't responded. Then I asked her for a hint and she said this (I'm copy pasting her text)-</p>
  <blockquote>
  <p>Create a separate table with col as operations and timestamp. Write statement level trigger on insert update and delete operations. The trigger will capture the operation fired and timestamp by inserting values in table.</p>
  </blockquote>
  <p>I am not getting what does that mean or how to do it! Can anyone help me solve this?</p>