Example 2 of PL/SQL Function:
create or replace function find_area
(Len in number, Wid in number)
return number
as
varea number;
begin
varea := Len * Wid;
return varea;
end;
SQL> select find_area (10, 30) area from dual;
AREA
---------
300
create or replace function find_area
(Len in number, Wid in number)
return number
as
varea number;
begin
varea := Len * Wid;
return varea;
end;
SQL> select find_area (10, 30) area from dual;
AREA
---------
300
No comments:
Post a Comment
Please Provide your feedback here