FOR I IN 1…4 LOOP
X := X+1;
PRINT CAST(X AS CHAR(10))||‘全局’;
/开始一个嵌套语句块/
DECLARE
X INT := 10; --局部变量X
BEGIN
FOR I IN 1…4 LOOP
X:=X+10;
PRINT CAST(X AS CHAR(10))||‘局部’;
END LOOP;
END;
/嵌套结束/
END LOOP;
END;
结果
SQL> CREATE OR REPLACE PROCEDURE PRO AS
2 X INT := 0; --全局变量X
3 BEGIN
4 FOR I IN 1…4 LOOP
5 X := X+1;
6 PRINT CAST(X AS CHAR(10))||‘全局’;
7 /开始一个嵌套语句块/
8 DECLARE
9 X INT := 10; --局部变量X
10 BEGIN
11 FOR I IN 1…4 LOOP
12 X:=X+10;
13 PRINT CAST(X AS CHAR(10))||‘局部’;
14 END LOOP;
15 END;
16 END LOOP;
17 END;
18 /
操作已执行
已用时间: 5.996(毫秒). 执行号:1834.
SQL> CALL PRO;
1 全局
20 局部
30 局部
40 局部