Oracle PL/SQL Einzel-Tipp ansehen

Subblöcke

Tipp 39

BEGIN

    <<Block_1>> ------------------------------- Block 1 ---------
    DECLARE
    var_i    number:=1;
    var_j    number:=1;

    BEGIN
        DBMS_OUTPUT.PUT_LINE(' Block 1,Variable var_i:='||var_i);
        DBMS_OUTPUT.PUT_LINE(' Variable var_j:='||var_j);
       
        <<Block_2>> ---------------------------- Block 2 (Subblock)--
        DECLARE
        var_i    number:=2;
        BEGIN
            DBMS_OUTPUT.PUT_LINE(' Block 2, Variable var_i:='||var_i);
            DBMS_OUTPUT.PUT_LINE(' Variable var_j:='||var_j);                       
        END Block_1;       
    END;
END;

/