Insert Cities in Oracle Bank

Asked

Viewed 115 times

1

Someone would have a query to insert in the Oracle database all Brazilian cities with accentuation and cedilla in the words?

I’m trying to find some on the internet, but all use Internet of multiple values and Oracle would have to write the syntax: INSERT INTO TABELA VALUE VALOR for each city.

I already have the table created with the columns: ID_MUNICIPIO, NM_MUNICIPIO and ID_ESTADO.

oracle

  • If you already have a text file with the cities you can replace it with some editor ex.: where you have it , replace by Insert into table (id_municipio, nm_municipio, id_estado) values (

1 answer

0


Follow the link, in this repository there is a lot: https://github.com/chandez/Estados-Cidades-IBGE in Municipios.sql you have the following structure:

Insert into Municipio (Codigo, Nome, Uf) values ('1100015','Alta Floresta D''Oeste', 'RO');

are more than 5 thousand records

  • 1

    Thanks I managed to use this repository.

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.