ALTER TABLE FOTOPRATOBLOB ADD FGFOTOPRATOURL_APP VARCHAR2(2000) NULL
/

ALTER TABLE QRCODELOCALPESQ ADD IDEXIBEFOTOAPP VARCHAR2(1) NULL
  CONSTRAINT CKC_IDEXIBEFOTOAPP CHECK(IDEXIBEFOTOAPP IN ('S','N'))
/

ALTER TABLE COMPCARDPESQ ADD NRORDEM NUMBER(15,5) NULL
/

UPDATE COMPCARDPESQ SET NRORDEM = TO_NUMBER(NRORDPRATCAR)
/

COMMIT
/