SELECT ABS(-15) “Absolute” FROM DUAL;

Absolute
———-
15

select ceil(268651.1) from dual;
SELECT FLOOR(15.9) “Floor” FROM DUAl;
SELECT ROUND(15.193,2) “Round” FROM DUAL;
SELECT MOD(11,4) “Modulus” FROM DUAL;
SELECT TRUNC(15.79,1) “Truncate” from dual;

SELECT ceil(15.197) “ceil”,FLOOR(15.197)”FLOOR”, ROUND(15.197,2) “Round”,MOD(15.197,2) “Modulus” ,TRUNC(15.197,2) “Truncate” FROM DUAL;

Suggested Posts:

Leave a Reply