HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
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 AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is an Oracle database Partial Backup?
Difference between transaction type and transaction sources. : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
as a technical developer in oracle applications which type errors feced in your experience sofar
What is Tax Categories?
how to write customizations in po
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
where the dff data will be stored
Explain the payment term in ar. : oracle accounts receivable
What is an Oracle database Full Backup?
Where in the Oracle directory tree structure are audit traces placed?
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?
How to clone the database using RMAN back