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: Attempting to get Result as "%"

Re: Attempting to get Result as "%"

From: MSWEENEY <MSWEENEY01_at_ADELPHIA.NET>
Date: 3 Feb 2006 04:51:56 -0800
Message-ID: <1138971115.952443.4010@g43g2000cwa.googlegroups.com>


Thank you for your responses. I now understand the ERROR message but am a bit confused about the to_char command. Again, I apologize for my ingorance of SQL as I am just learning.

Here is my SQL query (in pertinent part)

SELECT POSITIONTITLE, EMPLOYEE, SUPERVISOR, ((NVL(SUM(BACKOUT),0)/(SUM(ON_DUTY),0))-1) AS UTILIZATION FROM MMS_EMPL_UTILIZATION
GROUP BY POSITIONTITLE, EMPLOYEE, SUPERVISOR ORDER BY POSITIONTITLE, SUPERVISOR, EMPLOYEE Again, thank you for your assistance. Mark Received on Fri Feb 03 2006 - 06:51:56 CST

Original text of this message

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