-----
512
12.08 How to use remainder( )
function
Syntax: remainder(8,3) "remainder" from dual ;
It gives the remaining short value to make 8 as divisible
RESULT:
reminder
-1
12.09 How to use round( )
function
Syntax: select round(123456,89,-2) "round-2-100" from dual ;
RESULT:
round-2-100
----------------
123500
In this single value function, you can note down under round function, -2 indicates rounded to hundred, -1