oracle sql round code example
Example: oracle sql round
SELECT round(15.193, 1) AS "Round" FROM DUAL; -- 15.2
SELECT round(15.193, -1) AS "Round" FROM DUAL; -- 20
SELECT round(15.193, 1) AS "Round" FROM DUAL; -- 15.2
SELECT round(15.193, -1) AS "Round" FROM DUAL; -- 20