daily pastebin goal
70%
SHARE
TWEET

Untitled

a guest Apr 15th, 2018 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE TRIGGER Saku
  2.  AFTER UPDATE
  3. ON Shtat_R FOR EACH ROW
  4. DECLARE
  5. CURSOR c IS SELECT salary, SRno FROM Shtat_R WHERE SRno=3;
  6. UPDATE hist
  7. SET salary=c.salary
  8. WHERE SR_no=c.SRno;
  9. UPDATE hist
  10. SET data=SYSDATE
  11. WHERE SR_no=c.SRno;
  12. COMMIT;
  13. /
  14.  
  15. UPDATE Shtat_R
  16. SET salary=1250000
  17. WHERE SRno=3;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top