| 0 comments ]

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;

0 comments

AddThis

| More
Widget By Devils Workshop