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.