Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
Answer Posted / edara satish
More or less both the keys sounds same, but the major
diffrence is where unique will allow null values, because
each null treated as a diffrent value internally. Incase of
primary key it will not allow any repeated data and null
data.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Why does Oracle not permit the use of PCTUSED with indexes?
Is oracle the best database?
What is dual table oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is set operator oracle?
Explain the use of rows option in imp command.
What is Redo Log Buffer in Oracle?
Explain drop constraint oracle?
How to use "startup" command to start default instance?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is recycle bin in Oracle?
What is null value in oracle?
How to handle a single quote in oracle sql?
How does Oracle guarantee data integrity of data changes?
What is an oracle recycle bin?