Re: Simple rounding query

Jeremy wrote:

> Perhaps I'm being a bit thick here, but is there a single function call
> I can make in pl/sql (8.1.7.x) which wil round up to the next integer?
>
> I want:
> 29/10 = 3
> 30/10 = 3
> 31/10 = 4

z := trunc(x/y)+case x mod y when 0 then 0 else 1 end ;

Kind regards,

-- 
Stay hard, stay hungry, stay alive if you can
And meet me in a dream of this hard land

Cris Carampa (spamto:cris119_at_operamail.com)