Re: Help Urgent...Select Statement

Are you missing a close bracket on line 2.

Looking at the query I would of thought the hourly rate should be held on Sc_Details table, and so remove the need for a decode.

Best of luck.

grateful1_at_my-dejanews.com wrote:

> I have an assignment to complete for a beginner course in Oracle (that will
> only be 45 hrs total). I am having a problem with the script I created.
> Could someone please help? This is the question asked: There are 4
> technicians in the company: John, Maria, Nancy and Steve with the following
> hourly rates: John $25/hour, Maria $32/hour, Nancy $22/hour, Steve $30/hour.
> For every service call, create a SELECT statement that will provide the
> total cost(parts + labour).
>
> Here is the script I have up to now with the error it gave:
>
> SQL> SELECT own.name, photoc.Photocopier_Id, serv.Sc_Number,
> 2 SUM(prt.Prize +
> 3 SUM(DECODE
> 4 (det.Technician, 'John', 35, 'Maria', 32,
> 5 'Nancy', 22, 'Steve', 30, 0)
> 6 * det.Hours_Worked)) "Cost"
> 7 FROM Owners own, Photocopiers photoc, Parts prt,
> 8 Sc_Details det, Service_Calls serv
> 9 WHERE serv.Sc_Details = det.Sc_Number
> 10 AND det.Part_Id = prt.Part_Id
> 11 AND serv.Photocopier_Id = photoc.Photocopier_Id
> 12 AND photoc.Owner_Id - own.Owner_Id
> 13 GROUP BY own.Name, photoc.Photocopier_Id, serv.Sc_Number;
> GROUP BY own.Name, photoc.Photocopier_Id, serv.Sc_Number
> *
> ERROR at line 13:
> ORA-00920: invalid relational operator
>
> Can someone please help me with this error, I have tried to correct this
> without success. Thank you for your time. P.S. it is due on Friday.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 08:31:59 CST