oracle round、trunc、floor、ceil函数

复习下这几个函数吧

select round(1.3456) from dual; -- 1
select round(1.3456, 1) from dual; -- 1.3
select round(1.3456, 2) from dual; -- 1.35
select trunc(1.3456) from dual; -- 1.3
select trunc(1.3456, 1) from dual; -- 1.3
select trunc(1.3456, 2) from dual; -- 1.34

select round(-1.3456) from dual; -- -1
select round(-1.3456, 1) from dual; -- -1.3
select round(-1.3456, 2) from dual; -- -1.35
select trunc(-1.3456) from dual; -- -1.3
select trunc(-1.3456, 1) from dual; -- -1.3
select trunc(-1.3456, 2) from dual; -- -1.34

select ceil(1.3456) from dual; --2
select floor(1.3456) from dual; -- 1

select ceil(-1.3456) from dual; -- -1
select floor(-1.3456) from dual; -- -2
select trunc(-1.3456) from dual; -- -1

select power(2,10) from dual;
select sqrt(4) from dual;
select sqrt(3) from dual;