ALTER TABLE TIPOOPERAC ADD IDCUMUPISCOFIL VARCHAR2(1)   NULL
    CONSTRAINT CKC_IDCUMUPISCOFIL_TIPOOPERAC  CHECK (IDCUMUPISCOFIL IN ('S','N'))
/

ALTER TABLE FILIAL DROP CONSTRAINT CKC_IDCUMUPISCOFIL 
/

ALTER TABLE FILIAL ADD CONSTRAINT CKC_IDCUMUPISCOFIL CHECK (IDCUMUPISCOFIL IN ('S','N','A'))
/