This discussion is archived
3 Replies Latest reply: Dec 5, 2012 3:55 AM by Manu. RSS

query not working with oracle 6i forms

968357 Newbie
Currently Being Moderated
hello

i am trying to fetch data through CURSOR in orcle 6i forms.
i am using follwing query given below
------------
cursor c1 is
SELECT EXTRACT("YEAR FROM dateofmtrl") yr
     , SUM(CASE mtrl_flag WHEN 'P' THEN rm1 ELSE -rm1 END) AS opc 
     , SUM(CASE mtrl_flag WHEN 'P' THEN rm2 ELSE -rm2 END) AS ppc, 0 AS clinker
FROM rawmtrl_graph
GROUP BY EXTRACT(YEAR FROM dateofmtrl)
order by EXTRACT(YEAR FROM dateofmtrl);
-----------
But it is giving errors............

Please tell me how to overcome these errors

thanks in advance for any help....

With Regards
Vishal Agrawal

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points