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 use select statement to count the number of rows in oracle?
How to invoke the data pump export utility?
What is primefaces used for?
What are the restrictions in a oracle read only transaction?
What is translate in oracle?
What do you mean by merge in oracle and how can we merge two tables?
What to do if dba lost the system password?
How to use group functions in the select clause using oracle?
Explain parameter file in oracle.
How to create a table index in oracle?
What is an Oracle index?
How do I uninstall oracle client from windows?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to join two tables in a single query using oracle?
What is meant by raw datatype?