OraFAQ Forum: SQL & PL/SQL » Primary and Foreign key relationship

Home » SQL & PL/SQL » SQL & PL/SQL » Primary and Foreign key relationship (10.2.0.2.0 ,windows)

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

Primary and Foreign key relationship [message #427366]

Thu, 22 October 2009 04:23

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

Hi ,

I would like to know the relationship between Primary key and Foreign key constraint.
Will you provide me some good links or give some examples to start with it ?

Thanks

Report message to a moderator

Re: Primary and Foreign key relationship [message #427367 is a reply to message #427366]

Thu, 22 October 2009 04:30

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Constraints

Report message to a moderator

Re: Primary and Foreign key relationship [message #427375 is a reply to message #427367]

Thu, 22 October 2009 05:06

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

Can you provide links with good examples??

Report message to a moderator

Re: Primary and Foreign key relationship [message #427376 is a reply to message #427366]

Thu, 22 October 2009 05:07

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Always Oracle Documents Will give you clear And more information,If you still want some more Google that.
i.e.
http://www.techonthenet.com/oracle/index.php

Report message to a moderator

Re: Primary and Foreign key relationship [message #427378 is a reply to message #427375]

Thu, 22 October 2009 05:17

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Hitman11 wrote on Thu, 22 October 2009 11:06

Can you provide links with good examples??

I did. what was the problem with the link I posted?

Report message to a moderator

Re: Primary and Foreign key relationship [message #427383 is a reply to message #427378]

Thu, 22 October 2009 05:52

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

You did.but that link was not that much useful.From that link i could only understand
what is primary and foreign key?i need some examples on it.

Please provide some example if possible.

Report message to a moderator

Re: Primary and Foreign key relationship [message #427384 is a reply to message #427383]

Thu, 22 October 2009 05:57

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Hitman11 wrote on Thu, 22 October 2009 05:52

You did.but that link was not that much useful.From that link i could only understand
what is primary and foreign key?i need some examples on it.

Please provide some example if possible.

Did you really went through the links provided to you?

Report message to a moderator

Re: Primary and Foreign key relationship [message #427385 is a reply to message #427383]

Thu, 22 October 2009 05:58

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Hitman11 wrote on Thu, 22 October 2009 11:52

You did.but that link was not that much useful.From that link i could only understand
what is primary and foreign key?i need some examples on it.

Please provide some example if possible.

The link I provided contains examples. If that does not suffice, then simply google for it,then post back with any further, specific questions.

Report message to a moderator

Re: Primary and Foreign key relationship [message #427386 is a reply to message #427384]

Thu, 22 October 2009 06:01

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Ok, Here is more for you..with examples

[Updated on: Thu, 22 October 2009 06:01]

Report message to a moderator

Previous Topic:	column
Next Topic:	changing data with FOR UPDATE..WHERE CURRENT OF (merged 7)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:08:40 CST 2024