Number Functions

ROUND : Round values to specified decimal
TRUNC : Truncates values to specified decimal
MOD : Returns remainder of division

Function

Result

ROUND (45.926, 2)

45.93

TRUNC (45.926, 2)

45.93

MOD (1600, 300)

100



Select round (45.926, 2), trunc (45.926, 2), mod (1600,300)
From dual;






0 comments:

Post a Comment