ALTER TABLE PERIENTR ADD IDGRAVADTCONSUM VARCHAR2(1) NULL    
        CONSTRAINT CKC_PERIENTR_IDGRAVADTCONSUM CHECK (IDGRAVADTCONSUM IS NULL OR (IDGRAVADTCONSUM IN ('S','N')))
/
ALTER TABLE COLETAPR DROP CONSTRAINT CKC_CDTPINDICECOL
/
ALTER TABLE COLETAPR ADD CONSTRAINT CKC_CDTPINDICECOL CHECK (CDTPINDICECOL IN ('1','2', '3'))
/ 