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 are the features of pl sql?

1061

---

What is synchronized subquery?

1161

---

Why do we use joins in sql?

968

---

How can I see all tables in sql?

1064

---

What is the use of prepared statement?

1007

---

How do you optimize a stored procedure in sql?

948

---

What is not in sql?

941

---

What is composite primary key in sql?

992

---

What is before and after trigger?

953

---

How to read/write files from pl/sql?

1035

---

Can delete statement be rollbacked?

982

---

what are enums used for in mysql? : Sql dba

1166

---

What is the difference between cluster and non-cluster index?

1104

---

What is oracle pl sql developer?

978

---

Is sql a programming?

970

---