IS NOT NULL Operator in Oracle helps to identify those values that are not null. Not null values are those that represent some values contained in them.
Select column from Table_name where column IS NOT NULL;
We have a table names as Stu as shown below:
NOTE: In house section all the values are NULLS expect the last one i.e. Green.
So, to find the values that are not null under the House column is Stu table, follow the given code:
Select * from Stu where House IS NOT NULL;
The output above has displayed only the last row that is the row that contains not null value.