• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / condition / IS NULL in Oracle SQL PLSQL

IS NULL in Oracle SQL PLSQL

November 22, 2012 by techhoneyadmin

In Oracle SQL / PLSQL IS NULL is used to check whether the value of a literal is NULL or not.

Example 1:
Syntax to use IS NULL in IF statement is:
IF literal_name IS NULL THEN
<business_logic>
END IF;

Here if the literal_name has NULL value then the IF condition will evaluate to TRUE, then the “THEN” section of the code will get executed.

Example 2:

Using IS NULL is Oracle SQL / PLSQL SELECT statement:

Suppose we have a table named ‘employee’ as shown below:

Employee_ID Employee_Name Salary Department Commission
101 Emp A 10000 Sales
102 Emp B 20000 IT 20
103 Emp C 28000 IT 20
104 Emp D 30000 Support 5
105 Emp E 32000 Sales 10
106 Emp F 20000 Sales 5
107 Emp G 12000 Sales
108 Emp H 12000 Support

Suppose we want to see the records having commission as NULL, then we can achieve the same as:

SELECT *
FROM employee
WHERE commission IS NULL;

We will get the following results:

Employee_ID Employee_Name Salary Department Commission
101 Emp A 10000 Sales
107 Emp G 12000 Sales
108 Emp H 12000 Support

Here we can see that we have successfully retrieved records having NULL commission using IS NULL in Oracle SQL PLSQL SELECT statement.


Filed Under: condition Tagged With: how to use IS NULL in oracle database query, how to use IS NULL in oracle plsql, how to use IS NULL in oracle sql, IS NULL in oracle plsql, IS NULL in oracle sql, ISNULLPLSQL, syntax and example of IS NULL in oracle database query, syntax and example of IS NULL in oracle plsql, syntax and example of IS NULL in oracle sql, using IS NULL in oracle database query, using IS NULL in oracle plsql, using IS NULL in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in