What is the result, when NULL is compared with NULL?
Answer Posted / affan shemle
It is absolutely perfect to compare NULL with NULL. It
yields the result NULL. For those who are saying the result
is FALSE they are taking the answer from IF THEN ELSE. In
all the above answers supported by IF Statement there is a
catch. The result of IF is a Boolean. A Boolean can hold
TRUE, FALSE or NULL. So when you compare NULL vs NULL as a
condition of IF THEN, it returns NULL so the controller goes
to ELSE skipping the IF. Makes sense???
/
AFFAN SHEMLE
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is sql query limit?
What are the steps for performance tuning.
What do you understand by pl/sql cursors?
What is indexes?
Explain the types of joins in sql?
Which language is used in sql?
Whis is not false in primary key?
What is interval partition?
Why use triggers in sql?
What do you understand by pl/sql packages?
What are character functions in sql?
What is an intersect?
what is difference between delete and truncate commands? : Sql dba
What is sqlca in db2?
How to display the current date in sql?