what is difference between foreign key and reference key
Answer Posted / anup
very simple...we use primary key or foreign key whenever we need to make relation.ex..if we need to join student (Roll P.K) and marks(roll F.K.) then we can join both tables only if we have primary key in one table and foreign key in other..one table may have n numbers of foreign key and n number of primary key (Called composite key)..mail me if u need more details in oracle or any front end lang...anup from chennai,Ranchi.
Is This Answer Correct ? | 8 Yes | 27 No |
Post New Answer View All Answers
How to work with data objects interactively?
How to change program global area (pga) in oracle?
How can I create database in oracle?
How to export data to a csv file?
How to best split csv strings in oracle 9i?
What are the various oracle database objects?
How a tablespace is related to data files?
Differentiate between post-database commit and post-form commit?
What is the disadvantage of User defind function?
what is meant by magic query
Which is better Oracle or MS SQL? Why?
How do I manually uninstall oracle client?
6. Display the client name and order date for all orders using the traditional method.
What is oracle data type?
How to drop an existing view in oracle?