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 connect to the server with user account: sys?
Can you have more than one content canvas view attached with a window ?
How to create a new table in oracle?
What is flashback in Oracle?
How to connect asp pages to oracle servers?
Why cursor variables are easier to use than cursors?
How to drop a stored function?
What is dual table oracle?
What is a static data dictionary in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
various types of hints and their usage
What are the different types of modules in oracle forms?
How to use "if" statements on multiple conditions?
Explain about achiever in sql?