Sunday, February 22, 2009

Write a function to return area of triangle.

SQL> create or replace function area (b number,h number)

2 Return number is

3 a number;

4 begin

5 a:=1/2*b*h;

6 return a;

7 end;

8 /

Function created.


OUTPUT

SQL> select area(5,12) from dual;

AREA(5,12)

----------

30