create or replace trigger tr_dcs_dx_custom_point_u after update of point_id ON dcs_dx_custom_point FOR EACH ROW declare li_count int; BEGIN select count(*) into li_count from dcs_dx_custom_point_list t where t.point_id=:old.point_id; if(li_count>0) then update dcs_dx_custom_point_list m set m.point_id=:new.point_id where m.point_id=:old.point_id; end if; end;
我再给你一个: CREATE OR REPLACE TRIGGER update_student_loan_status AFTER UPDATE ON STUDENTS_FINES FOR EACH ROW BEGIN IF :NEW.sf_fine>10 THEN UPDATE students SET student_bl_status=’F’ WHERE students.student_id=:NEW.sf_student_id; ELSE UPDATE students SET student_bl_status=’T’ WHERE students.student_id=:NEW.sf_student_id; END IF; END;
after update of point_id ON dcs_dx_custom_point
FOR EACH ROW
declare
li_count int;
BEGIN
select count(*) into li_count from dcs_dx_custom_point_list t where t.point_id=:old.point_id;
if(li_count>0) then
update dcs_dx_custom_point_list m set m.point_id=:new.point_id where m.point_id=:old.point_id;
end if;
end;
CREATE OR REPLACE TRIGGER update_student_loan_status
AFTER UPDATE ON STUDENTS_FINES
FOR EACH ROW
BEGIN
IF :NEW.sf_fine>10 THEN
UPDATE students
SET student_bl_status=’F’
WHERE students.student_id=:NEW.sf_student_id;
ELSE
UPDATE students
SET student_bl_status=’T’
WHERE students.student_id=:NEW.sf_student_id;
END IF;
END;