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 define a record variable to store a table row?
What are the uses of a database trigger?
What is hot backup and logical backup?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to export your own schema?
What is index-organized table in Oracle?
What are the extensions used by oracle reports?
How to define an external table with a text file?
How do I learn what codesets are available in oracle?
Explain an exception?
What are the oracle built-in data types?
Can a parameter be passed to a cursor?
How to display row numbers with the records?
What happens to the current transaction if the session is ended?
How to create a new table by selecting rows from another table?