Can we use more than one null value for unique key?
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..!!
Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Can we insert data into view?
What is sql*plus?
what are aggregate and scalar functions? : Sql dba
What are the types of dbms?
what are set operators in sql? : Sql dba
What is difference between nchar and nvarchar?
Differentiate between pl/sql and sql?
What is a sql trace file?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the difference between a subquery and a join?
Why do we go for stored procedures?
What is primary key and unique key?
Advantages and disadvantages of stored procedure?
What are sql indexes?
What are user defined functions?