Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enter data for all the countries , states and their cities...

misterimranApr 4 2005 — edited Apr 8 2005

Hi Guys,

I am developing a travel module for my company. I have three basic tables that store the data for countries, states and cities of the world.

Like i have COUNTRY table with fields:
Country_ID
Country_Name

STATE table like:
Country_ID
State_ID
State_Name

TOWN table like
Country_ID
State_ID
Town_ID
Town_Name

I have to enter data for all the counties of the world their states againts each country and then cities belonging to that state.

Does anyone have such a data in dump format or in a script file so that i can populate my tables with that data. Or where from i can get such data so i can add it manually in my tables.

Please help, its very urgent and important for me.

Best regards,

Imran Baig
MisterImran@hotmail.com

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2005

Added on Apr 4 2005

#general-database-discussions

4 comments

722 views