OraFAQ Forum: SQL & PL/SQL » How can bulk insert into the parent , child tables

Home » SQL & PL/SQL » SQL & PL/SQL » How can bulk insert into the parent , child tables (Oracle Linux 6.7, Oracle 12.1.0.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can bulk insert into the parent , child tables [message #670473]

Sun, 08 July 2018 01:27

fabi88
Messages: 112
Registered: November 2011

Senior Member

There is is a flat file (CV file) which has Countries,Provinces and Cities information, like:

Germany, Berlin, Potsdam 
Germany, Hamburg, Altona
Germany, Hamburg, Reinbek

there are three tables in the database for keeping countries, provinces and cities, like:

# Country Table
Country_ID , Country_Name

# Province Table
Province_ID ,Country_ID (F.K to Country Table), Province_Name

# City Table
City_ID,Province_ID(F.K to Province Table) City_Name

how can bulk insert into the tables using something like external table ,... or any other methods which can be used for bulk insert?
I mean that how can bulk insert into the parent , child tables?

Thanks for your favor in advance.

Report message to a moderator

[Message index]

		How can bulk insert into the parent , child tables By: fabi88 on Sun, 08 July 2018 01:27
		Re: How can bulk insert into the parent , child tables By: John Watson on Sun, 08 July 2018 01:36
		Re: How can bulk insert into the parent , child tables By: fabi88 on Sun, 08 July 2018 01:56
		Re: How can bulk insert into the parent , child tables By: John Watson on Sun, 08 July 2018 03:55
		Re: How can bulk insert into the parent , child tables By: fabi88 on Sun, 08 July 2018 06:44
		Re: How can bulk insert into the parent , child tables By: Michel Cadot on Sun, 08 July 2018 07:56
		Re: How can bulk insert into the parent , child tables By: Solomon Yakobson on Sun, 08 July 2018 09:42
		Re: How can bulk insert into the parent , child tables By: Michel Cadot on Sun, 08 July 2018 02:30
		Re: How can bulk insert into the parent , child tables By: Barbara Boehmer on Sun, 08 July 2018 21:58
		Re: How can bulk insert into the parent , child tables By: Barbara Boehmer on Sun, 08 July 2018 23:14
		Re: How can bulk insert into the parent , child tables By: fabi88 on Tue, 10 July 2018 05:30

Previous Topic:	Report query
Next Topic:	rownum from table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:57:35 CDT 2024