A continuation of my notes as I study for the Oracle Certified Associate credential.
In this post, I’ve simply referenced available Oracle Functions and associated examples. For a more appropriate description, please view the Oracle Documentation Library.
Function:ROUND(number, precision)
select round(1631.7344,−3) from dual is 2000.
select round(1331.7344,−3) from dual is 1000.
select round(1631.7344,−4) from dual is 0.
select round(5631.7344,−4) from dual is 10000.
select round(123456.78) from dual is 123457. (rounds to the nearest whole number)
Function:TRUNC(number, precision)
select trunc(1631.7394,−3) from dual is 1000.
select trunc(1631.7394,2) from dual is 1631.73.
select trunc(1631.7394) from dual is 1631. (cuts decimal precision; creates whole number)
Function:MOD(dividend, divisor)
select mod(15,4) from dual is 3.
select mod(5,50) from dual is 5.
select mod(4.9,4) from dual is 0.9.
Posted via Woodland Blog (http://dramse01.blogspot.com)
RECOMMENDED