ALTER TABLE PRECOSECIAM ADD (
  IDCALCTABPROP VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  IDUTILLOADIGUAL VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE PRECOSECIAM ADD CONSTRAINT CKC_IDCALCTABPROP CHECK (IDCALCTABPROP IN ('N', 'S'))
/
ALTER TABLE PRECOSECIAM ADD CONSTRAINT CKC_IDUTILLOADIGUAL CHECK (IDUTILLOADIGUAL IN ('N', 'S'))