Oracle: IS NOT NULL Operator

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.

Syntax

Select column from Table_name
where column IS NOT NULL;

Example

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;

Output

The output above has displayed only the last row that is the row that contains not null value.