create or replace TRIGGER trig_ecc_ywdp_update BEFORE
INSERT OR UPDATE ON ecc_ywdp_kpi
FOR EACH ROW
BEGIN
:new.succ_rate := TO_CHAR(nvl(round(:new.succ_count /:new.res_count,4) * 100,0),'fm9999999990.00')
|| '%';
:new.tps :=TO_CHAR(nvl(round(:new.trade_count / 60,4),0),'fm9999999990.00');
END;