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 |
can we use lexical perameter in oracle plsql if yes how
can we drop dual table
What is store procedure?and how do u take the values from database and run in scripts?
i have marks in table,how to find total?
Differentiate between transaction type and transaction source? : oracle accounts receivable
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.
How can you enable a trace for a session?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is difference b/w Credit memo and Adjustment in AR.
How many segment are present in Oracle Manufacturing
what are the tools used for oracle 10g in real time.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha