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
What are the major difference between truncate and delete?
What is dynamic proxy?
How to create an oracle testing table?
Why do we use bulk collect in oracle?
How to turn on or off recycle bin for the session?
What are the differences between char and varchar2 in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is a procedure in oracle?
How do we create privileges in oracle?
How to create a table index in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What is Redo Log Buffer in Oracle?
What is meant by a deadlock situation?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?