NULL VALUES

• A null is a value that is unavailable, unassigned, unknown/inapplicable.
• It is not the same as zero or a blank space.

Example:

SELECT name,job_id, salary, comm FROM dept;

In arithmetic expression:

• Arithmetic expression containing a null value evaluate to null.

Example:
SELECT name, 12*salary*comm FROM employee;