Difference between primary key and unique key ?

Answer Posted / satya

Primery Key = (Unique key - NULL values)

One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.

Any comment? please shoot a mail.

Is This Answer Correct ?    329 Yes 90 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is index-organized table in Oracle?

571


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1662


What is the difference between sharding and partitioning?

501


How to list all indexes in your schema?

578


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

541






What happens to the current transaction if the session is killed?

536


types of indexes and the rationale behind choosing a particular index for a situation.

1982


How to put more than 1000 values into an oracle in clause?

586


Can we write dml statement in function in oracle?

632


How to create a new user account in oracle?

576


What is translate in oracle?

616


How can I see all tables in oracle?

540


How to drop a stored function?

672


What is null value in oracle?

631


How to get execution statistics reports on query statements?

567