Example of Function is oracle

-- Created on 8/7/2012 by TAHIR

declare

  -- Local variables here

   c number;

begin

  -- Test statements here

  c:=xyz(20,20);

  dbms_output.put_line(c);

 

end;

create or replace function xyz( a number, b number) return number

is

x number;

begin

x:=a+b;

return x;

end xyz;