1、一个block定义 begin end 2、如果内部bolck有与外层的block相同变量名,同时要用到外部变量,就需要为外部block在declare请定义一个名词比如outter,用<<outter>>,引用时用outter.变量名词 3、举例: set serveroutput on set verify off <<outer>> declare aa number := 2; begin <<inner>> declare aa number :=3; begin dbms_output.put_line("---------normal output--------"); dbms_output.put_line("inner.aa:" || aa); dbms_output.put_line("outer.aa:" || outer.aa); end;
exception when zero_divide then dbms_output.put_line("------exception-------"); end; / 结果: ---------normal output-------- inner.aa:3 outer.aa:2 |