Oracle数学相关函数小结

select abs(-2) value from dual;

select ceil(-2.001) value from dual;(-2)

select floor(-2.001) value from dual;(-3)

select trunc(-2.001) value from dual; (-2)

select round(1.234564) value from dual;(1.2346)

select power(4,2) value from dual;(16)

select sqrt(16) value from dual;(4)

select sys.dbms.random.value(0,1) value from dual;

select sign(-3) value from dual;(-)

select greatest(-1,3,5,7,9) value from dual;(9)

select least(-1,3,5,7,9) value from dual;(-1)

select nvl(null,10) value from dual;(10)

select ascii(a) value from dual;

select chr(97) value from dual;

select concat("11","22") value from dual;(1122)

select sysdate value from dual;

select trunc(sysdate) from dual;

select to_char(sysdate,"hh24:mm:ss") from dual;

select INITCAP(abc def ghi) value from dual;(Abc Def Ghi)