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
How to get a list of all background sessions in the database?
What is oracle update statement with inner join ?
What is tns name?
How to speed up webrick?
What is a procedure in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
what is the use of system.effective.date variable in oracle?
Explain about achiever in sql?
What is snapshot is too old? Give and example for better understand.
what's query optimization and without use of IN AND Exist can we get another way data from query
What is PL/SQL ?
Give the constructs of a package, function or a procedure.
What happens if the update subquery returns multiple rows?
Can group functions be mixed with non-group selection fields?
What is instant client oracle?