목록Round (1)

헤르메스 LIFE

[Oracle] TRUNC, ROUND 차이

TRUNC : 버림ROUND : 올림 TRUNC(1239.19, -2)ROUND(1239.19, -2) 값 TRUNC 결과 ROUND 결과 1239.19, -2 1200 1200 1239.19, -1 1230 1240 1239.19 1239 1239 1239.19, 1 1239.1 1239.2 1239.19, 2 1239.19 1239.19 CREATE OR REPLACE FUNCTION F_ROUNDUP( P_NUM IN NUMBER, P_PLACE IN INTEGER := 0)RETURN NUMBERISvBase NUMBER;BEGINIF (P_NUM = 0) THENRETURN 0;END IF;vBase := 10 ** P_PLACE ; -- POWER(10, P_PLACE)RETURN CEIL(A..
Database 2015. 10. 2. 15:33
이전 Prev 1 Next 다음