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

How to use regular expression in pattern match conditions in oracle?

573


What are the built-in functions used for sending Parameters to forms ?

2839


How to view the data files in the current database?

590


How many types of database triggers exist?

569


what is the scripts in data base?

1600






What is sharded cluster?

518


How to convert a date to char in oracle? Give one example.

583


How to call a stored function with parameters?

561


How to write an inner join with the where clause in oracle?

581


How to export your connection information to a file?

592


How can Oracle users be audited?

601


What are ddl statements in oracle?

588


What is materialized view in Oracle?

630


What is a snapshot in oracle database?

567


How to estimate disk space needed for an export job?

558