82

ORACLE IS NOT NULL

In oracle, IS NOT NULL is used to check not null values. It is used with select, insert, update, and delete statements.

Syntax

Parameters

expression: column name or any value to check it is a not null value

Note:

1. In IS NOT NULL, condition returns true values.
2. In NULL, condition returns false.

Table:

Example 1

Query: select * from table1 where name is not null