行级触发器
CREATE OR REPLACE TRIGGER student_trig
AFTER update OF stuname ON STUDENTSFOR EACH ROW
BEGIN
DBMS_OUTPUT.PUT_LINE('旧的stuname值是' || :old.stuname ||'、新的stuname值是' || :new.stuname);
END;
update students set stuname = '新张三' where stuid='001'
行级触发器
CREATE OR REPLACE TRIGGER student_trig
AFTER update OF stuname ON STUDENTS