USING NAMED BLOCKS TO INCREASE VISIBILITY:
Sql> <
DECLARE
A VARCHAR2(30):='Hello Guys';
B REAL:=300;
BEGIN
DBMS_OUTPUT.PUTLINE('The Value of Outer String A is available Here:='||A);
DBMS_OUTPUT.PUTLINE('The Value of Outer Real B is available Here:='||B);
DECLARE
A INTEGER :=2000;
B REAL:=400;
BEGIN
DBMS_OUTPUT.PUTLINE('The Value of Inner Integer A is available Here:='||A);
DBMS_OUTPUT.PUTLINE('The Value of Inner Real B is available Here:='||B);
DBMS_OUTPUT.PUTLINE('The Value of Outer String A is available Here:='||FirstBlock.A);
END;
END;
[7:57 PM
|
0
comments
]



0 comments
Post a Comment
Do comment to make this blog better