ALTER TABLE PARAMPEDIDO ADD IDALTDTENTAPROV VARCHAR2(1)NULL
   CONSTRAINT CKC_IDALTDTENTAPROV CHECK (IDALTDTENTAPROV IS NULL OR (IDALTDTENTAPROV IN ('S','N')))
/

ALTER TABLE PEDIDO DROP CONSTRAINT CKC_IDORIGPED
/ 
ALTER TABLE PEDIDO ADD CONSTRAINT CKC_IDORIGPED CHECK (IDORIGPED IS NULL OR (IDORIGPED IN ('1','2','3','4','5','6','7','8','9','E','T','A')))
/