Javatpoint Logo
Javatpoint Logo

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:

ORACLE IS NOT NULL

Example 1

Query: select * from table1 where name is not null

ORACLE IS NOT NULL
Next TopicIS NULL




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA