17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger tri_1
before insert or delete or update on A
for each row
declare
pragma autonomous_transaction;
begin
update B set num=num+1 where B_TID=:new.tid;
commit;
end;
SELECT enterpriseid FROM tb_brandinfo WHERE brandid = (SELECT distinct(tb_dressupinfo.brandorproductid) FROM tb_dressupinfo where tb_dressupinfo.brandorproductid = 1)
create or replace
TRIGGER DRESSUP_UPDATE_TRIGGER
BEFORE INSERT OR DELETE OR UPDATE ON TB_DRESSUPINFO
FOR EACH ROW
DECLARE
ENTERID NUMBER(32,0);
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
SELECT b.enterpriseid INTO ENTERID FROM tb_brandinfo b WHERE b.brandid = (SELECT DISTINCT(t.brandorproductid) FROM tb_dressupinfo t WHERE t.brandorproductid=:old.brandorproductid);
UPDATE tb_interface_update t SET t.UPDATE_VERSION_NO = t.UPDATE_VERSION_NO+1, t.update_date=sysdate,t.enterpriseid=ENTERID WHERE t.update_id=1 AND t.enterpriseid =ENTERID;
END;
create or replace
TRIGGER DRESSUP_UPDATE_TRIGGER
BEFORE INSERT OR DELETE OR UPDATE ON TB_DRESSUPINFO
FOR EACH ROW
DECLARE
V_ENTERID NUMBER(32,0);
pragma autonomous_transaction;
BEGIN
IF UPDATING OR DELETING THEN
SELECT b.enterpriseid INTO V_ENTERID FROM tb_brandinfo b WHERE b.brandid = (SELECT brandorproductid FROM tb_dressupinfo t WHERE t.brandorproductid=:new.brandorproductid);
UPDATE tb_interface_update t SET t.UPDATE_VERSION_NO = t.UPDATE_VERSION_NO+1, t.update_date=sysdate,t.enterpriseid=V_ENTERID WHERE t.update_id=1 AND t.enterpriseid =V_ENTERID;
ELSIF INSERTING THEN
UPDATE tb_interface_update t SET t.UPDATE_VERSION_NO = t.UPDATE_VERSION_NO+1,t.update_date=sysdate,t.enterpriseid=V_ENTERID WHERE t.update_id=1 AND t.enterpriseid =V_ENTERID;
END IF;
COMMIT;
END;