what is the difference between primary key & foreign key?
Answer Posted / mathiyarasan
Primary is unique one. Each table has only one primary key.
But not allow null values.
Foreign key is opposite of primary. It is reference of
primary key from another table. It allow Null value. Each
table can have more than one foreign key.
Foreign key is used to link one to another table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
How to use "for" statements in oracle?
What are the oracle built-in data types?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Please explain compound trigger in oracle?
What happens if recursive calls get out of control?
What is snapshot is too old? Give and example for better understand.
 How to use an oracle sequence generator in a mapping?
What is an oracle user account?
How to convert times to characters in oracle?
How to login to the server without an instance?
How to convert characters to numbers in oracle?
What is a view and how is it different from a table?
What do you mean by merge in oracle and how can you merge two tables?
how may join possible between (requisition with purchase order)