[Oracle] 숫자 내장 함수

1. ABS - 절대값

SELECT ABS(35), ABS(-35) FROM DUAL; // 35, 35

 

2. SIGN - 양수/음수/0 확인

SELECT SIGN(35), SIGN(-35), SIGN(0) FROM DUAL; // 1, -1, 0

 

3. ROUND - 반올림

SELECT ROUND(34.35), ROUND(34.63) FROM DUAL; // 34, 35
SELECT ROUND(34.352, 2), ROUND(34.637, 2) FROM DUAL; // 34.35, 34.64

 

4. TRUNC - 몫

SELECT TRUNC(17/5) FROM DUAL; // 3

 

5. MOD - 나머지

SELECT MOD(17,5) FROM DUAL; // 2

 

6. POWER - 제곱

SELECT POWER(5,2) FROM DUAL; // 25

 

7. SQRT - 제곱근

SELECT SQRT(25) FROM DUAL; // 5