[Oracle SQL] 숫자함수

/* Number function */
/* 
    dual : 오라클에서 제공되는 dummy table, 테이블이 없을 때 사용 
    all 
    distinct : 중복제거
*/
 
 
/* abs() : 절대값 */
 
select abs(-23) 
from dual;
 
 
 
/* sign() */
 
select sign(23), sign(-23), sign(0) 
from dual;
 
 
 
/* round(n1,n2) : 반올림 */
 
select round(0.123), round(0.543), round(0.125) 
from dual;
 
 
select round(0.123456789,6), round(0.543465,2), round(0.125254,4) 
from dual;
 
 
 
/* trunc(n1,n2) : 소수점 자르기 */
 
select trunc(1234.1234567) zero 
from dual;
 
 
select trunc(1234.1234567,0) 
from dual;
 
 
select trunc(1234.1234567,2) 
from dual;
 
 
select trunc(1234.1234567,-1) 
from dual;
 
 
 
/* ceil() : 올림 */
 
select ceil(32.8) ceil 
from dual;
 
 
select ceil(32.3) ceil 
from dual;
 
 
 
/* floor() : 내림 */
 
select floor(32.8) floor 
from dual;
 
 
select floor(32.3) floor 
from dual;
 
 
 
/* power(n1,n2) : 제곱 */
 
select power(4,2) power 
from dual;
 
 
 
/* mod(n1,n2) : 나머지 */
select mod(7,4) mod 
from dual;
 
 
/* sqrt() : 제곱근 */
select sqrt(2), sqrt(3) 
from dual;