ALTER TABLE PROGRAMACAOPESQ ADD (
  IDFREQRESPOSTA VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE PROGRAMACAOPESQ ADD CONSTRAINT CKC_IDFREQRESPOSTA_PROGRAMPESQ CHECK (IDFREQRESPOSTA IN ('S','N'))