ALTER TABLE LISTAREDZ ADD IDORIGEM VARCHAR2(01) NULL
/

ALTER TABLE LISTAREDZ ADD IDVALIDACAO VARCHAR2(01) DEFAULT 'N'
   CONSTRAINT CKC_IDVALIDACAO_LISTAREDZ CHECK (IDVALIDACAO IN ('S','N','E','A'))
/