• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help

 
smitha verghese
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anybody let me know whats the error here?
SELECT DATE1, NAME, SUM(LINE_COUNT) AS LCOUNT, AVG(QUALITY) AS ACCURACY, UNDER98
FROM (SELECT DATE1,NAME,UNDER98
IF QUALITY< 98
BEGIN
SUM(LINE_COUNT) AS UNDER98
END
FROM PRODUCTION) GROUP BY DATE1, NAME;
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Smitha,
I may be misinterpreting your question here, but when I tried your SQL on an Oracle 8i (8.1.7.4) database on a SUN [sparc] with Solaris 7 (using SQL*Plus), I got this error:

IF QUALITY< 98
*
ERROR at line 12:
ORA-00923: FROM keyword not found where expected

Is that what you were looking for?
Good Luck,
Avi.
[ June 28, 2003: Message edited by: Avi Abrami ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic