Difference between primary key and unique key ?
Answer Posted / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Respected sir, Please send me technical questions related to oracle apps..
How to insert a new row into a table in oracle?
How to write a query with a left outer join in oracle?
State any two functions of oracle?
Explain the difference between sap and oracle?
What are the different oracle database objects?
Why cursor variables are easier to use than cursors?
How to pass a cursor variable to a procedure?
What is using clause and give example?
What is a procedure in oracle?
master table and child table performances and comparisons in Oracle ?
What is logical backup in oracle?
Explain what are clusters?
What is the data pump import utility?
How to update values in a table in oracle?