Interested to Buy Any Domain ? << Click Here >> for more details...
Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
- 1 Answers
- 4847 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramachandra
we are using primary key and foreign key database designer identify an entity
diffencee b/w primary key and foreign key
1.every table should have one primary key
but foreign key it doesnt any rule we keep more than one foreign key
2.primary key doesn't accept null values
3primary key is parent key
but foreign key is child key it depends only primary key table or column it doesn't allow more than primary key column attributes.
4.primary key doesn't accept duplicate values
but foreign key accepting duplicate values
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why more redos are generated when the oracle database is in begin backup mode?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
i want to know about the javaBean.what is its purpose and how it can use in Forms.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
what is semphore explian it?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the use of lockboxes? : oracle accounts receivable
What Are Cross Validation & Adi?
as a technical developer in oracle applications which type errors feced in your experience sofar
which one is currently in used software cmpanies.
what is difference between inner join & nested query or subqueries
please send me oracle pl/sql exp resume. and also faqs...
