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
Top comments (0)