title: Oracle trigger- update record after update on same table
body: <p>I want to make trigger in oracle database. when some one change the status its status again change to unpaid so that other user can use same number for payment.
  I have write below code but it not change status.
  Please help me in this regard. Thankyou.</p>
  <pre><code>CREATE OR REPLACE TRIGGER PAY.TRG_UPDATE_NUMBER
  
  AFTER UPDATE ON PAY.MYBILL
  
  BEGIN
  
  UPDATE PAY.MYBILL
  
  SET STATUS='U'
  
  WHERE MYNUMBER='123456789';
  
  END;
  </code></pre>