|
SQL> --
SQL>
SQL> create or replace function getArea (i_rad NUMBER)
2 return NUMBER
3 is
4 begin
5 return 3.14*(i_rad**2);
6 end;
7 /
Function created.
SQL>
SQL>
SQL>
SQL> select text
2 from user_source
3 where name = 'GETAREA'
4 order by line;
/
TEXT
-------------------------------------------------------------------------
function getArea (i_rad NUMBER)
return NUMBER
is
begin
return 3.14*(i_rad**2);
end;
6 rows selected.
SQL>
SQL>
|