drop function if exists getsalary
//
create function getsalary() returns numeric
begin

   declare l_salary numeric(13,2);
   
   set l_salary  =  1000000.00;  

   return l_salary;
   
end
//