Home » SQL & PL/SQL » SQL & PL/SQL » import ... PK & FK relation
import ... PK & FK relation [message #185001] Sat, 29 July 2006 13:29 Go to next message
novicess
Messages: 8
Registered: July 2006
Junior Member
How do I smartly import data from db_table to 2 destination tables, where one table BOOK has a FK_author, referring to a PK_id in table AUTHOR. (the PK and FK is not imported)
Secondly several books have the same author, so when do I merge the fields in Author?
I created a sequence trg for PK_id author, but should the FK in book have a sequence trg as well... nooo can't be.
Thank you for every hint.
Re: import ... PK & FK relation [message #185314 is a reply to message #185001] Tue, 01 August 2006 03:21 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Where is the data coming from? You say 'import data from db_table' - do you mean you are trying to split the data in a table out into two other tables, or are you importing the data into the database from outside?

Previous Topic: Format and sign of currency in SQL*plus
Next Topic: Query
Goto Forum:
  


Current Time: Sat Dec 03 00:54:45 CST 2016

Total time taken to generate the page: 0.13088 seconds