Explanation and handling of NULL value in Oracle Database

Null value is causing lots of confusion to many people. Here is a quick summary on some key points regarding NULL in Oracle.