Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between foreign key and reference key
- 3 Answers
- 42439 Views
- AZTEC, Infosys, I also Faced
- E-Mail Answers
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 operators in oracle?
How to get execution path reports on query statements?
How to select all columns of all rows from a table in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Can we use bind variables in oracle stored procedure?
How view is different from a table?
How to drop an existing table in oracle?
Explain the use of show option in imp command.
What are the differences between date and timestamp in oracle?
How do I spool in oracle?
What is the maximum number of triggers that can be applied to a single table?
What do you mean by a deadlock?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to find the duplicate rows count from employees table in oracle?
