ROUND with precision : ROUND « Numeric Math Functions « Oracle PL / SQL
- Oracle PL / SQL
- Numeric Math Functions
- ROUND
ROUND with precision
SQL>
SQL>
SQL> --Consider the following example:
SQL>
SQL> SELECT ROUND(44.647, 2) AS POSITIVE FROM Dual;
POSITIVE
----------
44.65
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(44.647, -1) | | |
7. | ROUND(Number,1): round values from column | | |
8. | ROUND(Number,0) | | |
9. | ROUND(Number,-1) | | |
10. | Round an AVG function | | |
11. | Use ROUND function in PL/SQL | | |
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 | | |