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