Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

2.2 KiB

Raw Permalink Blame History

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;
/

Parent topic: Control Statements

2.2 KiB Raw Permalink Blame History

NULL Statements

Syntax

2.2 KiB

Raw Permalink Blame History