ALTER TABLE ADMINCARTAO ADD NMBAIRRO VARCHAR2(50)
/
UPDATE ADMINCARTAO
   SET NMBAIRRO = CDBAIRRO
 WHERE CDBAIRRO IS NOT NULL
/
COMMIT
/
ALTER TABLE ADMINCARTAO MODIFY NMBAIRRO VARCHAR2(50)
/
ALTER TABLE ADMINCARTAO ADD CDLOGRADOURO VARCHAR2(04)
/