강의_2장_02_숫자 관련 함수.pdf

20230411155114.png

실습

ROUND: 반올림

SELECT 987.654
    ,ROUND(987.654,2)
    ,ROUND(987.654,0)
    ,ROUND(987.654,-1)
    ,ROUND(987.654,-2)
    FROM DUAL;

20230411155541.png

TRUNC: 반내림

SELECT 987.654
    ,TRUNC(987.654,2)
    ,TRUNC(987.654,0)
    ,TRUNC(987.654,-1)
    ,TRUNC(987.654,-2)
    FROM DUAL;

20230411155642.png

MOD: 나머지

SELECT 987.654
    ,MOD(987.654,100)
    ,MOD(987.654,10)
    ,MOD(987.654,1)
    ,MOD(987.654,2)
    FROM DUAL;

20230411155832.png

CEIL: 올림

SELECT 987.654
    ,CEIL(987.654)
    ,CEIL(654)
    ,CEIL(987.3)
    ,CEIL(920)
    FROM DUAL;