ROUND CEIL FLOOR ETC..

SELECT CEIL(12345.67) FROM dual; --Smallest integer greater than or equal to a decimal value

SELECT floor(12345.67) FROM dual;--- Returns the largest integer less than or equal to a decimal value

SELECT round(12345.67) FROM dual;

SELECT trunc(12345.67) FROM dual;

SELECT GREATEST(9, 67.6, 10) FROM dual;

SELECT LEAST(9, 67.6,10) FROM dual;


SELECT MEDIAN(initial_extent) FROM all_tables ; ---Returns the middle value of a set

SELECT EXP(2) FROM dual;