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 can I introduce multiple conditions in like operator?
How to commit the current transaction in oracle?
How can we find out the duplicate values in an oracle table?
What is translate in oracle?
Calculate difference between 2 date / times in oracle sql?
Can a parameter be passed to a cursor?
what is the scenario where you take the database to NoArchivelog mode?
How to assign query results to variables?
How to start your 10g xe server?
How to invoke the original export import utilities?
How to use fetch statement in a loop?
Will you be able to store pictures in the database?explain.
What are named parameters?
How to execute a stored procedure in oracle?
What are the arithmetic operations?