Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


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:

Syntax

SELECT col1, col2, ...
FROM tablename
WHERE expression IS NULL;

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:

Example

SELECT firstName, lastName, address 
FROM tblCustomerLoan
WHERE address IS NULL;

Note:

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