ALTER TABLE PARASUPRI ADD (
  IDPERGUNTATUSCPEDOL VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  IDATUALIZASCPEDOL VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDATUALIZASCPEDOL CHECK (IDATUALIZASCPEDOL IN ('S','N'))
/
ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDPERGUNTATUSCPEDOL CHECK (IDPERGUNTATUSCPEDOL IN ('S','N'))