I did the testing:
<<block1>>
declare
a number := 20;
begin
dbms_output.put_line(a);
<<block2>>
declare
a number :=10;
begin
dbms_output.put_line(block1.a);
dbms_output.put_line(a);
end block2;
end block1;Result:
20
20
10So the result is not like what you describle .
Please check it out .
<<block1>>
declare
a number := 20;
begin
dbms_output.put_line(a);
<<block2>>
declare
a number :=10;
begin
dbms_output.put_line(block1.a);
dbms_output.put_line(a);
end block2;
end block1;Result:
20
20
10So the result is not like what you describle .
Please check it out .
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货