yes it is equivalent as primary key is nothing but unique and not null.

If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Question Posted / bhakti

Answer Posted / bhakti

yes it is equivalent as primary key is nothing but unique
and not null.

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Can we write dml statement in function in oracle?

1077

How to define a record variable to store a table row?

1048

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2055

Why oracle is used?

1045

Explain drop constraint oracle?

1051

What is a subquery?

1115

What is a nested table and how is it different from a normal table?

1044

How to set up autotrace for a user account?

1051

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3193

Give the various exception types.

987

What is the difference between alert log file and tarce file ?

2164

What privilege is needed for a user to connect to oracle server?

987

can u plz provide me oca sql dumps please i need them

1941

What is the difference between translate and replace?

1053

Is there any function in oracle similar like group_concat of mysql?

1048