Basic Statements

This section begins the discussion of programming statements used in SPL programs.

NULL

The simplest statement is the NULL statement. This statement is an execution statement and does not produce an actual operation.

NULL;

The following is the simplest SPL program.

BEGIN  
  NULL;
END;

When a statement like IF-THEN-ELSE is executed, the NULL statement can operate as a placeholder.

Example:

\set PLSQL_MODE on
CREATE OR REPLACE PROCEDURE divide_it (
    p_numerator IN NUMBER,
    p_denominator IN NUMBER,
    p_result OUT NUMBER
)
IS
BEGIN
    IF p_denominator = 0 THEN
        NULL;
    ELSE
        p_result := p_numerator / p_denominator;
END IF;
END;
/
\set PLSQL_MODE off