Re: Simple rounding query

Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.1b3a10a5f005d4cb989c66_at_news.individual.net>...
> 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
>
> ?

It's called CEIL (short for ceiling):

SQL> select ceil(29/10) from dual;

CEIL(29/10)

          3

SQL> select ceil(30/10) from dual;

CEIL(30/10)

          3

SQL> select ceil(31/10) from dual;

CEIL(31/10)

          4 Received on Wed Jun 16 2004 - 13:10:03 CDT