Can we use more than one null value for unique key?
Answer Posted / rajesh
yes,we can use more than one null value for unique key.
Bcz all null values are unique,
thing is that null is unknown ,unassignable,
undefind ,inapplicable value and allwase null is not equal
to null and any arithimitic operation and logical
comparision all wase result null
| Is This Answer Correct ? | 21 Yes | 9 No |
Post New Answer View All Answers
How do I remove all records from a table?
what are integrity rules?
Explain locks? : Transact sql
What are the qualities of 2nf?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How do I run a sql query?
What is raw datatype in sql?
What is foreign key and example?
How to use boolean type in select statement?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is bind variable in pl sql?
How to change the order of columns in Oracle SQL Plus ?
What is difference between joins and union?
What is output spooling in sql*plus?
Which command is used to delete a package?