In oracle, IS NULL is used to check not null values. It is used with select, insert, update, and delete statements.
expression IS NULL
expression: column name or any value to check it is a null value
Query: select * from table1 where name is null