jinpeng0的专栏

--更新payment 的status,orderid,issue 触发 CREATE OR REPLACE TRIGGER "UPDATE_ORDER_STATUS_ISSUE" AFTER UPDATE OF STATUS, ORDERID, ISSUE ON PAYMENT FOR EACH ROW BEGIN IF :OLD.STATUS != :NEW.STATUS THEN UPDATE ORDER SET PAYMENTSTATUS = :NEW.STATUS