sql program

set serveroutput on size 30000;
declare
var_pi   number(8,2);
var_r   number(8);
var_area   number(10,2);
begin
var_pi :=&var_pi;
var_r :=&var_r;
var_area:=var_pi*var_r*var_r;
dbms_output.put_line('area of circle=' || var_area);
end;
/





set serveroutput on size 30000;
declare
var_l   number(8);
var_b   number(8);
var_area   number(10);
begin
var_l:=&var_l;
var_b:=&var_b;
var_area:=var_l*var_b;
dbms_output.put_line('area of rectangle =' || var_area);
end;
/
Previous
Next Post »
Thanks for your comment