Difference between primary key and unique key ?
Answer Posted / ibrahim
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.
but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the minimum client footprint required to connect c# to an oracle database?
What is the data type of dual table?
What is a sub query? Describe its types?
What are the different types of modules in oracle forms?
How to load a large xml file?
What is the sid in oracle?
How to retrieve values from data fields in record variables?
Is oracle an open source?
Which is better Oracle or MS SQL? Why?
What is system global area (sga) in oracle?
How to best split csv strings in oracle 9i?
Difference between oracle's plus (+) notation and ansi join notation?
How to view the tablespaces in the current database?
In which language oracle has been developed?
How to create a new table in oracle?