Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Attempting to get Result as "%"
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