Oracle PL/SQL - NULL Statement as Placeholder During Subprogram Creation

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Statement
  4. NULL Statement

Introduction

In the following code, the NULL statement lets you compile this subprogram and fill in the real body later.

Demo

SQL>
SQL>-- from  ww w  .  j  a v  a  2  s .  com
SQL> CREATE OR REPLACE PROCEDURE award_bonus (
  2    emp_id NUMBER,
  3    bonus NUMBER
  4  ) AS
  5  BEGIN    -- Executable part starts here
  6    NULL;  -- Placeholder
  7    -- (raises "unreachable code" if warnings enabled)
  8  END award_bonus;
  9  /

Procedure created.

SQL>

Related Topic