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 -> need to narrow down value

need to narrow down value

From: MSWEENEY <MSWEENEY01_at_ADELPHIA.NET>
Date: 24 Feb 2006 04:25:52 -0800
Message-ID: <1140783952.492688.194790@u72g2000cwu.googlegroups.com>


I have a query where a function calculates a percentage. Now I just want to get the answer rounded to the nearest 10ths.

Example:

sum(c.pp_hours/b.hours*100)||'%' as Percent_pp

result: 95.7446808510638297

I tried the following:

sum(c.pp_hours/b.hours*100, 1, 5)||'%' as Percent_pp

and got the error: ORA-00909: invalid number of arguments

How do I round this off to the tenths?

Thanks for all of the help!!! Received on Fri Feb 24 2006 - 06:25:52 CST

Original text of this message

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