Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65419 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 do we need cursor in pl sql?
What is a sql statement?
How to convert comma separated string to array in pl/sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is transaction control language (tcl)?
Does google use sql?
How many types of functions are there in sql?
Explain the the delete statements in sql?
What is the advantage of nosql?
Can we rollback truncate?
what is cursor. write example of it. What are the attributes of cursor.
What is primary key and foreign key?
How bulk collect improves performance?
How do you define a foreign key?
What operating systems are supported by oracle sql developer?
