Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18023 Views
- Genpact, I also Faced
- E-Mail Answers
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
Which is faster join or subquery in oracle?
Explain an exception?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the benefits of ordbms?
material view and view disadvantages?
How to load data through external tables?
What are ddl statements in oracle?
How do I uninstall oracle 11g?
What is oracle join syntax?
How can Oracle users be audited?
Write a trigger example in oracle?
What are the different editions of oracle?
How to get execution path reports on query statements?
Explain the use of consistent option in exp command.
What is a data dictionary and how can it be created?
