Can we use more than one null value for unique key?
- 31 Answers
- 60326 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / arika
We can insert duplicate nul values in palce of using unique
key constrint.Because all nulls are not equal.
ex:-
select * from emp where comm=null;
explenation;
here equal operator not support null value because
all nulls are not equal
ex:-
select * from emp where comm is null;
explenation:
'is' operator suport null
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you join a table to itself?
What is sql*plus?
What is substitution variable?
Is null operator in sql?
What is a natural join?
Which command is used to delete a package?
Can a table have no primary key?
How does pl sql work?
What are inner and outer joins examples of both?
What is sql and db2?
What is auto increment feature in sql?
Which sorts rows in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is difference between hql and sql?
How do you write a complex sql query?
