Orcale SQL Tutorial
Loading...
Is Not Null
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:
- In IS NOT NULL, condition returns true values.
- In NULL, condition returns false.
Table:
Example 1
Query: select * from table1 where name is not null |