---

Oracle IS NULL Operator

In Oracle IS NULL operator is used to check for IS NULL value. If expression is a NULL value, the condition evaluates to TRUE otherwise FALSE.

Oracle IS NULL OPERATOR Syntax

To check for the IS NULL value in the field, use the following syntax:

Parameters:

tablename: The table name from which you want to perform IS NULL operator.

expression: To test specifies value if it is NULL value.

Oracle IS NULL OPERATOR example

The following Oracle, IS NULL operator is used to check for the IS NULL value in the "address" field:

Note:

In the above example, we are performing IS NULL operator to check for the NULL value in the "address" field.

---

---