Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to connect to the server with user account: sys?

1024


Can you have more than one content canvas view attached with a window ?

2333


How to create a new table in oracle?

1159


What is flashback in Oracle?

1022


How to connect asp pages to oracle servers?

1073


Why cursor variables are easier to use than cursors?

1094


How to drop a stored function?

1139


What is dual table oracle?

987


What is a static data dictionary in oracle?

1115


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?

2465


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.

2129


various types of hints and their usage

2699


What are the different types of modules in oracle forms?

1001


How to use "if" statements on multiple conditions?

1174


Explain about achiever in sql?

1042