Monday, March 2, 2009

Labeled Block

An Anonymous Block

Declare
v_Ctr Number(3) := 1;
Begin
Dbms_Output.Put_Line(v_Ctr);
End;
/

A Named Block

<<l_Named_Block>>
Declare
v_Ctr Number(3) := 1;
Begin
Dbms_Output.Put_Line(v_Ctr);
End l_Named_Block;
/

No comments:

Post a Comment