Oracle: IS NULL Operator

Null Values in Oracle are nothing but it represents that no values are present in the existing place. IS NULL Operator in oracle returns the null values present in the database. 

Null Values are therefore mistaken by 0 by most people. However, Null Values are not considered as 0, in fact, it displays empty values.

Syntax

Select Column from Table_name
 where Column IS NULL;

Example

We have a Stu table as shown below:

NOTE: We can find that on the above pasted table, we have various null values under House column. Only the last values have the not null values. Let's test this with help of code:

Select * from Stu 
where House IS NULL;

Output

All the entries with NULLS are displayed as an output.