ALTER TABLE FABRICANTE ADD (
  CDQUALIF VARCHAR2(2) DEFAULT NULL NULL, 
  DTVALQUALIF DATE DEFAULT NULL NULL, 
  IDPERCMPDFE VARCHAR2(1) DEFAULT 'N' NULL
)
/
ALTER TABLE FABRICANTE ADD CONSTRAINT CKC_IDPERCMPDFE_B CHECK (IDPERCMPDFE IS NULL OR (IDPERCMPDFE in ('S','N')))