Answer Posted / amit rajoria

Yes, we can use multiple Null values in case of Unique Key
Column. This is one the main difference between Unique Key
and Primary Key that Unique Key always allows multiple
entries of Null Statement where as Primary Key never allows
this.

I am hereby giving you a very very basic example which
suggests that Unique Key can have more than one Null
Statement :-

SQL> create table abcd(name varchar2(10) unique);

Table created.

**********************

Now insert the values :-

SQL> insert into abcd(name)values('amit');

1 row created.

SQL> insert into abcd(name)values('ami');

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from abcd;

NAME
----------
amit
ami



Here blank space above represents the entries of null
statements..!!

What is the difference between in and between in sql?

1004

---

What is primary key in db?

943

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1598

---

How do I make sql search faster?

947

---

What are sql queries used for?

989

---

difference between anonymous blocks and sub-programs.

1083

---

What is compound trigger?

971

---

What is relationship? How many types of relationship are there?

1083

---

Why do we use joins in sql?

919

---

What is java sql driver?

1048

---

Differentiate between % rowtype and type record.

1212

---

What is primary key sql?

964

---

What is an inner join sql?

963

---

How do I count duplicates in sql?

1043

---

What are the types of index in sql?

1022

---