ALTER TABLE FILIAL ADD CDCONTTRANSIT VARCHAR2(20) NULL
/

ALTER TABLE FILIAL ADD IDCONTTRANSIT VARCHAR2(1) DEFAULT 'N' NULL
   CONSTRAINT CKC_IDCONTTRANSIT_FILIAL CHECK (IDCONTTRANSIT IN ('S','N'))
/