Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 66479 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
Differentiate between % rowtype and type record.
Is sql difficult?
Explain commit, rollback and savepoint.
What is sqlcontext?
What is the use of sql trace?
How to add new employee details in an employee_details table with the following details
how many columns can be used for creating index? : Sql dba
What is mutating error?
how to include comments in sql statements? : Sql dba
Can sql developer connect to db2?
What are predefined functions in sql?
Explain constraints in sql?
What is structural independence and why is it important?
what is offset-fetch filter in tsql? : Transact sql
What is the purpose of normalization?
