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
- 4934 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
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
What are different types of transactions in ar? : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Where in the Oracle directory tree structure are audit traces placed?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How would you go about increasing the buffer cache hit ratio?
What is auto invoicing? : oracle accounts receivable
