Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
Answer / 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 |
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
what is domain in database and its benefits?
what is debit memo and credit memo in AR?
how can it possibble to see the report output in excel sheet in oracle applications
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
i want to know about the javaBean.what is its purpose and how it can use in Forms.
How do you switch from an init.ora file to a spfile?
What is the use of lockboxes? : oracle accounts receivable
what are the advantages of Oracle over other databases..? please give me reply...
When a user process fails, what background process cleans up after it?
how to create an user in oracle 10g.please give me an example..