Orcale SQL Tutorial
Loading...
Is Null
ORACLE NULL
In oracle, IS 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 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 null |