Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview
PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.
Download the book in PDF, ePub, Kindle for a complete version.
-----
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