NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL;   TRUNC Let’s try some different usages of the TRUNC function. SELECT TRUNC (45.923), TRUNC (45.943, 1), TRUNC (45.953, 2), TRUNC (45.923, -1), TRUNC (45.923, -2) … Continue reading Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)