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;