ORACLE NULL

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

Syntax

snippet
expression IS NULL

Parameters

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

Note:

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

Table:

ORACLE NULL

Example 1

Query: select * from table1 where name is null

ORACLE NULL
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +