Enter Cities in the Oracle database

1

Would anyone have a query to insert into the Oracle database all Brazilian cities with accent and cedilla in the words?

I'm trying to find some on the internet, but all use insert of multiple values and in 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 .

    
asked by anonymous 13.12.2017 / 14:55

1 answer

0

Follow the link, in this repository there is enough thing: link in Municipios.sql you have the following structure:

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

are more than 5mil records

    
13.12.2017 / 15:00