Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need to narrow down value
MSWEENEY schrieb:
> Maxim Demenko wrote: >
> > > I'm unable to go to the sight above due to constraints on my computer > system. I'm not sure what you mean when you say that a SUM is an > expression and not a list. >
For provided example this should work:
round(sum(c.pp_hours/b.hours*100),10)||'%' as Percent_pp
where 10 stands for number of decimal places right of the decimal point.
However, i wonder, how can one work with Oracle without having access to
Oracle documentation.
Best regards
Maxim Received on Fri Feb 24 2006 - 07:18:13 CST