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|
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 TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Explain how to close periods in ar. : oracle accounts receivable
how to replace not in with not exist?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
What is supporting issues GL AP and AR?
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what is the difference between TRUNCATE and DELETE command in SQL
I would like to study certification course in Data base adminidtrator then where would i go to study this course?