ALTER TABLE CONTOPECTBL ADD (
  IDCONSDTMOVIRETEST VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE CONTOPECTBL ADD CONSTRAINT CKC_IDCONSDTMOVIRETEST_CONTOPE CHECK (IDCONSDTMOVIRETEST IN ('S','N'))