|
|
Re: how to I make relationships between tables in oracle [message #351652 is a reply to message #351648] |
Thu, 02 October 2008 00:04  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Like in real life, these tables should first know of each other, i.e. the should meet somewhere, somehow. It might be because they are in the same schema, or one user has granted required privileges (such as SELECT or REFERENCES).
Next step is to start a relationship. Blind date? Not likely; referential integrity constraints enforced by foreign keys are the way to do that (as Michel has already said).
Now it takes only some time, a cup of coffee and documentation studying in order to happily get those table married.
|
|
|