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 sap sql anywhere?

1163

---

Is coalesce faster than isnull?

1017

---

What is the best partition size for windows 10?

1049

---

Explain what is a view?

1115

---

Why is theta join required?

1188

---

How do I restart sql?

1024

---

What is sql exception?

1012

---

Which sql most popular?

1029

---

How many types of relationship are there?

1082

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

---

Is sql a backend language?

1144

---

What is forward declaration in pl sql?

1140

---

what is a composite primary key ? : Sql dba

1092

---

how can we know the count/number of elements of an array? : Sql dba

1107

---

How to create an array in pl/sql?

1121

---