The Primarykey Constraint= unique + Not Null constraints. For the Unique t

What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?

Question Posted / allin

3 Answers
7146 Views
I also Faced
E-Mail Answers

Answer Posted / allin

The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.

Thanks & Regards,
RatnaRao
9833847339

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How remove data files before opening a database?

995

What are the differences between number and binary_float in oracle?

1050

How to create a server parameter file?

1079

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1283

What is Library Cache in Oracle?

1070

How to store pictures on to the database?

922

What is private procedure oracle?

952

Explain oracle’s server parameter file.

946

How to write a query with a left outer join in oracle?

997

How to execute a stored procedure in oracle?

1027

How to assign values to data fields in record variables?

970

Why packages are used in oracle?

999

what happened to the global index when I truncate the data in one of the partition?

1959

What is a package ? What are the advantages of package ?

1033

what is a Nested Loop join?

2035