Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple rounding query

Re: Simple rounding query

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Wed, 16 Jun 2004 09:47:31 +0100
Message-ID: <MPG.1b3a197224cd45d7989c68@news.individual.net>


In article <caovo8$eh1$1_at_panco.nettuno.it>, Cris Carampa says...
>
>
> z := trunc(x/y)+case x mod y when 0 then 0 else 1 end ;
>
>

OK looks like it uses the same method (expressed differently) as the solution I created.

Thanks!

-- 

jeremy
Received on Wed Jun 16 2004 - 03:47:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US