有一张财务资金表funds,有6个字段
name sh_balance sales prize pay dq_balancezhang 212 22 20 23 wang 23 49 33 43
zhan 22 33 45 56ding 54 34 67 88yu 34 56 87 49
当前余额(dq_balance)= sh_balance + prize + pay - sales我想每次更新sh_balance 、prize 、pay、sales的任何一个,当前余额(dq_balance)都在变,怎么写??? 是不是要分2张表呢??
name sh_balance sales prize pay dq_balancezhang 212 22 20 23 wang 23 49 33 43
zhan 22 33 45 56ding 54 34 67 88yu 34 56 87 49
当前余额(dq_balance)= sh_balance + prize + pay - sales我想每次更新sh_balance 、prize 、pay、sales的任何一个,当前余额(dq_balance)都在变,怎么写??? 是不是要分2张表呢??
BEFORE INSERT OR UPDATE
ON funds
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
:NEW.dq_balance := (:NEW.sh_balance + :NEW.prize + :NEW.pay - :NEW.sales);
EXCEPTION
WHEN OTHERS
THEN
-- Consider logging the error and then re-raise
RAISE;
END;
/