TEXT |
---|
TRIGGER trigger_valor_pedido AFTER INSERT OR UPDATE ON atendimento REFERENCING NEW AS NOVO FOR EACH ROW DECLARE v_total NUMBER; PRAGMA AUTONOMOUS_TRANSACTION; BEGIN SELECT SUM(I.qtd*P.preco) INTO v_total FROM atendimento ate, inclui I, prato P WHERE ate.data_atendimento = I.data_atendimento AND ate.data_atendimento = :NOVO.data_atendimento; UPDATE atendimento SET total = v_total; END; |