decode(:new.BUDGET_ACCESS_TYPE,
10,
:new.ACCESS_SUM,
20,
:new.ACCESS_SUM,
30,
:new.ACCESS_SUM),
DECODE(:new.BUDGET_ACCESS_TYPE, 90, :new.ACCESS_SUM) +
DECODE(:new.BUDGET_ACCESS_TYPE, 50, :new.ACCESS_SUM),
10,
:new.ACCESS_SUM,
20,
:new.ACCESS_SUM,
30,
:new.ACCESS_SUM),
DECODE(:new.BUDGET_ACCESS_TYPE, 90, :new.ACCESS_SUM) +
DECODE(:new.BUDGET_ACCESS_TYPE, 50, :new.ACCESS_SUM),
decode(条件,值A,返回值A,值B,返回值B,...值n,返回值n)呵呵 不对请指正.