DECLARE
a integer := 30;
b integer := 40;
c integer;
f real;
BEGIN
c := a + b;
dbms_output.put_line('Value of c: ' || c);
f := 100.0/3.0;
dbms_output.put_line('Value of f: ' || f);
END; Value of c: 70
Value of f: 33.33333333333333333333333333333333333333
DECLARE
a integer := 30;
b integer := 40;
c integer;
f integer;
BEGIN
c := a + b;
dbms_output.put_line('Value of c: ' || c);
f := 100.0/3.0;
dbms_output.put_line('Value of f: ' || f);
END; Value of c: 70
Value of f: 33
DECLARE
num1 number :=1;
num2 number :=2;
BEGIN
dbms_output.put_line('Global variable : ' || num1);
dbms_output.put_line('Global variable : ' || num2);
DECLARE
num1 number :=3;
num2 number :=4;
BEGIN
dbms_output.put_line('Local variable : ' || num1);
dbms_output.put_line('Local variable : ' || num2);
END;
dbms_output.put_line('Global variable : ' || num1);
dbms_output.put_line('Global variable : ' || num2);
END; Global variable : 1
Global variable : 2
Local variable : 3
Local variable : 4
Global variable : 1
Global variable : 2