drop trigger emps.bi_emps_fer
//

create trigger bi_emps_fer before insert on emps for each row
begin 
   
   declare newsal numeric default 0;
   declare namelength, l_loop int default 0;
   
   set namelength = length(new.emp_name);
   
   while l_loop < namelength do 
      
      set newsal := newsal + new.salary;
      
      set l_loop := l_loop + 1;
      
   end while;
   
   set new.salary = newsal;

end
//