How to use the ROUND, TRUNC and MOD function in Oracle sql. with examples.

ROUND function is used when you need to round decimal number to the closest one. https://youtu.be/TTCyvIQzFZE Round numbers: ROUND Examples: SELECT ROUND(45.923,2), ROUND(45.923,0), ROUND(45.923,-1) FROM DUAL; TRUNC function: TRUNC function…

Continue reading