الحل الامثل لمشكلة التقريب فى الارقام العشرية

declare



num_1        number(10,2) :=&p_number;



num_2          number(10,2);



begin if num_1 - trunc(num_1) = 0 then



dbms_output.put_line(num_1);



else



if num_1 - trunc(num_1 , 0) <= 0.04  then



num_2 := trunc(num_1 , 0 ) +0.05 ;



dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.06 and 0.10 then



num_2 := trunc(num_1 , 0 ) +0.10 ;



dbms_output.put_line(num_2);







elsif num_1 - trunc(num_1 , 0)  between  0.11 and 0.15 then



num_2 := trunc(num_1 , 0 ) +0.15 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.16 and 0.20 then



num_2 := trunc(num_1 , 0 ) +0.20 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.21 and 0.25 then



num_2 := trunc(num_1 , 0 ) +0.25 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.26 and 0.30 then



num_2 := trunc(num_1 , 0 ) +0.30 ;





dbms_output.put_line(num_2);



elsif num_1 - trunc(num_1 , 0)  between  0.31 and 0.35 then



num_2 := trunc(num_1 , 0 ) +0.35 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.36 and 0.40 then



num_2 := trunc(num_1 , 0 ) +0.40 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.41 and 0.45 then



num_2 := trunc(num_1 , 0 ) +0.45 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.46 and 0.50 then



num_2 := trunc(num_1 , 0 ) +0.50 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.51 and 0.55 then



num_2 := trunc(num_1 , 0 ) +0.55 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.56 and 0.60 then



num_2 := trunc(num_1 , 0 ) +0.60 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.61 and 0.65 then



num_2 := trunc(num_1 , 0 ) +0.65 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.66 and 0.70 then



num_2 := trunc(num_1 , 0 ) +0.70 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.71 and 0.75 then



num_2 := trunc(num_1 , 0 ) +0.75 ;



dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.76 and 0.80 then



num_2 := trunc(num_1 , 0 ) +0.80 ;



dbms_output.put_line(num_2);



elsif num_1 - trunc(num_1 , 0)  between  0.81 and 0.85 then



num_2 := trunc(num_1 , 0 ) +0.85 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.86 and 0.90 then



num_2 := trunc(num_1 , 0 ) +0.90 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.91 and 0.95 then



num_2 := trunc(num_1 , 0 ) +0.95 ;





dbms_output.put_line(num_2);





elsif num_1 - trunc(num_1 , 0)  between  0.96 and 1 then



num_2 := trunc(num_1 , 0 ) +1 ;





dbms_output.put_line(num_2);





end if ;



end if ;



end;