---

Oracle IS NOT NULL Operator

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

Oracle IS NOT NULL OPERATOR Syntax

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

Parameters:

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

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

Oracle IS NOT NULL OPERATOR example

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

Note:

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

---

---