ALTER TABLE VENDITEMPED ADD IDCARGOVEND VARCHAR2(1)
/

ALTER TABLE VENDITEMPED ADD CONSTRAINT CKC_IDCARGO_VENDITEMPED  CHECK (IDCARGOVEND IN ('V','G','S','A'))
/