ALTER TABLE TIPOOPERAC ADD (
  IDNFCRED VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE TIPOOPERAC ADD CONSTRAINT CKC_IDNFCRED CHECK (IDNFCRED IN ('S','N'))