Oracle ceil for decimal numbers

Question

When rounding to 2 decimal places, the value 4.01132141 will be rounded to 4.02, since it exceeds 4.01.

How can you do this in PL / SQL?

+3

K ratnajyothi 10 sept. '10 at 7:03

5 answers

Jonathan Leffler · Answer 1 · 2010-09-10T07:07:33+0000

The "round up" function is CEIL , but it generates an integer.

The function "round down" is FLOOR , but it also generates an integer.

The round function is near ROUND , and it allows you to specify the number of decimal places (dp).

, CEIL ; 2 , 100, CEIL 100.

, :

ROUND(value+0.005, 2)

, 4.01132141 , ROUND, 4.01632, 2 4.02. 4.0593, , , ROUND, 4,0643, 2 4,06, .

:

Alex Poole · Answer 2 · 2010-09-10T07:07:23+0000

- ceil(value*100)/100, . , round , .

Alex Deux · Answer 3 · 2012-01-23T19:03:22+0000

: .

select 4.01132141+(mod((ceil(4.01132141)-4.01132141)*1000,10)/1000) from dual

Joy Ruhe · Answer 4 · 2015-09-16T19:21:27+0000

4.01132141, CEIL (4.01132141 * 100)/100

Jaydip Mehta · Answer 5 · 2016-11-04T10:17:17+0000

PLSQL: ROUND (UrNo + (5/POWER (10, DecimalPlaces + 1)), DecimalPlaces)