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.


Select Column from Table_name
 where Column IS NULL;


We have a Stu table as shown below:

is null operator

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;

is null operator

All the entries with NULLS are displayed as an output.