Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64305 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
Why having clause is used in sql?
what is 'trigger' in sql? : Sql dba
What do you think about pl/sql?
What is trigger types of trigger?
What are synonyms in sql?
What are the main features of cursor?
What do you understand by exception handling in pl/sql?
How to prepare for oracle pl sql certification?
How do I filter in sql profiler?
Is left join inner or outer by default?
What is normalization? How many normalization forms are there?
What is an oracle stored procedure?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What are sql*plus environment variables?
What can you do with pl sql?
