Home » Developer & Programmer » Precompilers, OCI & OCCI » Unsupported OVER Keyword
Unsupported OVER Keyword [message #94408] Thu, 14 October 2004 23:02
A.G.Chandrashekhar
Messages: 2
Registered: October 2004
Junior Member
Hi,
I have a sql query similar to following:

SELECT product_seq, event_source MAX(product_seq) OVER (PARTITION BY event_source) max_product_seq
FROM pvcusteventsource;

And table desc:

Name Null? Type
PRODUCT_SEQ NOT NULL NUMBER(9)
EVENT_SOURCE NOT NULL VARCHAR2(40)

I see OVER keyword is not being supported by proc. I am using following version on AIX & Solaris.
(Pro*C/C++: Release 9.2.0.5.0 - Production on Fri Oct 15 07:03:44 2004)
Can I have help in modifying the query without OVER keyword or any other work around?
Thnaks in Advance.
-shekhar
Previous Topic: URGENT!!! HELP ME Please ... UNABLE to Insert into ORACLE
Next Topic: Pro C Compilation Error: ".so is up to date"
Goto Forum:
  


Current Time: Thu Mar 28 06:52:31 CDT 2024