Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Code with Conditional Control to Avoid an Exception

SQL> SQL> create or replace function f_get_speed(i_distance NUMBER, i_timeSec NUMBER)   2  return NUMBER   3  is   4    v_out number:=0;   5  begin   6    if i_timeSec!=0 then   7      v_out:= i_distance/ i_timeSec;   8    end if;   9   return v_out;  10  end;  11  / Function created. SQL> SQL> declare   2      v_speed NUMBER;   3  begin   4      v_speed:=f_get_speed(10,0);   5  end;   6  / PL/SQL procedure successfully completed. SQL>