Interested to Buy Any Domain ? << Click Here >> for more details...
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 10209 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj byregowda
Primary key- A column (or columns)in a table which makes every row in table unique. eg - EMPLOYEE table, EMPID is column which is unique.
Foreign Key - A column (or columns) in table Whose value References to primary key of another table OR ( A column which derives its value from another tables primary key.)
eg - EMP table EMPID is PK and DEPTNO is FK.
DEPT table DEPTID is pk.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can u give guidance abt packages of plsql
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
how to write customizations in po
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
Give two methods you could use to determine what DDL changes have been made.
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What Are Cross Validation & Adi?
as a technical developer in oracle applications which type errors feced in your experience sofar
default triggers available for reports
What is the disk migration? what is the steps involved in oracle disk migration?
What is Restricted Mode of Instance Startup in Oracle?
