Oracle触发器

行级触发器

CREATE OR REPLACE TRIGGER student_trig

  AFTER update OF stuname ON STUDENTS
  FOR EACH ROW
BEGIN
  DBMS_OUTPUT.PUT_LINE('旧的stuname值是' || :old.stuname ||'、新的stuname值是' || :new.stuname);
END;


update students set stuname = '新张三' where stuid='001'