Use ROUND function in PL/SQL
SQL>
SQL> set serveroutput on
SQL>
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE(ROUND(3.5));
3 DBMS_OUTPUT.PUT_LINE(ROUND(105.09,1));
4 DBMS_OUTPUT.PUT_LINE(ROUND(-3.5));
5 DBMS_OUTPUT.PUT_LINE(ROUND(105.15,-2));
6 DBMS_OUTPUT.PUT_LINE(ROUND(150.15,-2));
7 END;
8 /
4
105.1
-4
100
200
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category
| 1. | ROUND: Returns the number rounded to nearest value (precision adjustable) | | |
| 2. | Syntax: ROUND(,) | | |
| 3. | Specifying negative precision will round numbers on the left side of the decimal point, as shown here: | | |
| 4. | ROUND(5.75) | | |
| 5. | Simple demo for ROUND: round a number | | |
| 6. | ROUND with precision | | |
| 7. | ROUND(44.647, -1) | | |
| 8. | ROUND(Number,1): round values from column | | |
| 9. | ROUND(Number,0) | | |
| 10. | ROUND(Number,-1) | | |
| 11. | Round an AVG function | | |
| 12. | round Demo | | |
| 13. | Round date to day | | |
| 14. | Round price as new price | | |
| 15. | Round result from months_between | | |
| 16. | Rounding Up and Down | | |
| 17. | Rounds 7:45:26 P.M. on May 25, 2005, to the nearest hour | | |
| 18. | Rounds May 25, 2005, to the first day in the nearest month | | |