ORACLE FUNCTIONS

SCALAR functions(Single row functions)

NUMERIC function,ABS(absolute)


select * from dual;

select 14*14 from dual;

select abs(-5)from dual;

select power(2,3) from dual;

select power(price,2) from market;

select round(15.21,1)from dual;

select sqrt(16) from dual;

select greatest(5,3,7) from dual;

select least(5,3,7) from dual;

select mod(5,3) from dual;

select trunc(14.32) from dual;