SQL>SELECT ABS(-5000) FROM DUAL; =5000
SQL>SELECT CEIL(123.55) FROM DUAL; =124
SQL>SELECT FLOOR(123.55) FROM DUAL; =123
SQL>SELECT MOD(101,2) FROM DUAL; =1
SQL>SELECT POWER(2,4) FROM DUAL; =16
SQL>SELECT ROUND(123.55), ROUND(123.55,1) FROM DUAL; 124 123.6
SQL>SELECT SQRT(64) FROM DUAL; =8
SQL>SELECT TRUNC(123.55,0), TRUNC(123.55,1) FROM DUAL; 123 123.5
Prof. Ashay Dharwadker