TRIGGER

CREATE OR REPLACE TRIGGER update_mhs
after UPDATE ON mahasiswa FOR each ROW
BEGIN
INSERT INTO history_mhs VALUES(:NEW.npm,:NEW.nama,:NEW.par,:NEW.jur,:old.nama,:old.par,:old.jur,CURRENT_DATE);
END;

CREATE OR REPLACE TRIGGER delete_mk
after DELETE ON matkul FOR each ROW
BEGIN
UPDATE status_mk SET status='Tidak Tersedia' WHERE kd_mk=:old.kd_mk;
END;