Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65272 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
How to disable a trigger name update_salary?
What are primary key and foreign key and how they work?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are the triggers associated with image items?
What are inbuilt functions in sql?
How do you define a foreign key?
What is the reports view in oracle sql developer?
Does sql backup shrink transaction log?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is the difference between rename and alias?
what are sequences
What is trigger in flip flop?
how to run 'mysql' commands from a batch file? : Sql dba
What are the constraints available in sql?
Is sql difficult?
