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
- 4849 Views
- I also Faced
- E-Mail Answers
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 |
Give the stages of instance startup to a usable state where normal users may access it.
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
When the procedures or packagess become invalidate
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
What is supporting issues GL AP and AR?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is an Oracle database Full Backup?
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
Oracle General 
