Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

-----

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