ALTER TABLE PARASUPRI ADD (
  IDCONSARREDCMPAPUR VARCHAR2(1) DEFAULT NULL NULL
)
/
ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDCONSARREDCMPAPUR CHECK (IDCONSARREDCMPAPUR IS NULL OR (IDCONSARREDCMPAPUR IN ('S', 'N')))