Difference between primary key and unique key ?

Answer Posted / yogesh kumar

primary key is unique define in a table, it means if u
declare primary key value is not allows duplicate and null.

unique key allows repeats' a value and null.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you change old and new values in an insert, delete and update triggers?

545


What is enter substitution variable in oracle?

573


What is oracle rowcount?

580


What is a system tablespace and when it is created?

563


Explain the difference between replace() and translate() functions in oracle?

582






What is merge statement used for?

570


Is a rollback possible to any savepoint?

558


How to compare dates in oracle sql?

659


Explain oracle insert into command?

632


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1965


is there a tool to trace queries, like profiler for sql server?

611


What is the difference between online and offline backups?

562


How to execute the package in oracle?

572


How to define a sub function?

671


What is Library Cache in Oracle?

645