CREATE TABLE TEST(CURR)AS
(
SELECT 123.163612 FROM DUAL UNION ALL
SELECT 1237.1728788 FROM DUAL UNION ALL
SELECT 2828.2282811 FROM DUAL UNION ALL
SELECT 282.1886 FROM DUAL
)
Expected result:
Output:
123.1636
1237.17288
2828.22828
282.19
When I tried the round() got result below
SELECT ROUND(CURR,4) FROM test;
ROUND(CURR,4)
123.1636
1237.1729
2828.2283
282.1886