Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
Answer Posted / arti kesharwani
No they are not equal because
we can have more than one column with not null+Unique constraints but we can have only one primary key in the table.
e.g
we can not create a table like this
create table test(id number primary key , name varchar2(10) primary key)
but we can create
create table test(id number unique not null , name varchar2(10) unique not null)
Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is SQL Tuning Advisor in Oracle?
What is connection pooling in oracle?
What is an oracle cursor variable?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What privilege is needed for a user to create indexes in oracle?
Can we call procedure inside function in oracle?
how to make an oracle object
What is where clause in oracle?
How to create a new table by selecting rows from another table?
Is oracle a language?
How to do paging with oracle?
What is the difference between sharding and partitioning?
Does oracle database need java?
what is the dual table in oracle?
What is a user role in oracle?