alter table PEDICLILIBERAR ADD ENTREGAEXPRESSA NUMBER(1,0);
commit;
CREATE OR REPLACE TRIGGER PEDICLICOMPLIBERAR_IUD BEFORE
INSERT OR UPDATE OF ENTREGAEXPRESSA ON PEDICLICOMPLEMENTO FOR EACH ROW declare
nCount integer; sNome char(30);
begin
nCount :=0;
update PEDICLILIBERAR set  ENTREGAEXPRESSA=:new.ENTREGAEXPRESSA where NUMPED = :NEW.NUMPED;
end;