Advertisement
Guest User

Untitled

a guest
Jan 30th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE
  2.   TRIGGER trig_status_batal
  3.   AFTER UPDATE OF status
  4.   ON pendaftaran
  5.   FOR EACH ROW
  6.   BEGIN
  7.      IF :NEW.status = 'Batal' THEN
  8.              UPDATE pelatihan SET kuota = kuota+1 WHERE id_pelatihan = :OLD.id_pelatihan;
  9.      END IF;
  10.   END;
  11.   /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement