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