Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ Stored Procedures/ Control Statements/ NULL Statements
Updated on 2025-08-19 GMT+08:00
View PDF

NULL Statements

In PL/SQL programs, NULL statements are used to indicate "nothing should be done", equal to placeholders. They grant meanings to some statements and improve program readability.

Syntax

The following shows example use of NULL statements:

1
2
3
4
5
6
7
8
9
 
DECLARE
    ...
BEGIN
    ...
    IF v_num IS NULL THEN
        NULL; -- No data needs to be processed.
    END IF;
END;
/

Parameter description:

  • v_num: specifies the variable or expression.

Example

gaussdb=# DECLARE
    v_num integer default NULL;
BEGIN
    IF v_num IS NOT NULL THEN
        raise info 'v_num is NULL'; 
    ELSE
        NULL; -- No data needs to be processed.
    END IF;
END;
/
ANONYMOUS BLOCK EXECUTE
Parent topic: Control Statements