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..!!

How to install oracle sql developer?

1043

---

Can we perform dml on view?

1044

---

Are pl sql variables case sensitive?

1047

---

Sql technical questions

1280

---

What does trigger mean in psychology?

962

---

Is sql a microsoft product?

952

---

What is before trigger?

1000

---

What is sqlerrd?

968

---

What is indexing oracle sql?

1105

---

how to create a table index in mysql? : Sql dba

1061

---

Write the command to remove all players named sachin from the players table.

1184

---

What is substitution variable in pl sql?

1044

---

Explain the commit statement.

1159

---

What is the use of desc in sql?

977

---

What do we need to check in database testing?

1017

---