analytic functions

[amortillaro]

Hi all, I have here the version 806 of oracle db.
I need to know from which version of the database the analytics functions are implemented.
I know that for versions 8xx the analytics functions are not implemented for the pl/sql (

http://www.quest-pipelines.com/newsletter-v3/0402_D.htm

under the topic ANALYTIC FUNCTIONS AND PL/SQL). But then, where are they implemented since I try to create a view and it didn't work.
Thanks..Aishel

 

[amortillaro]

Oh! Here is my sql statement:

Select EmKey, AttDate,
ROW_NUMBER() OVER (PARTITION BY EmKey ORDER BY AttDate) LinkDiscretShadow
From Att_view
Where (AttDate >= To_Date('01/01/2004','MM/DD/YYYY'))

Thanks again... Aishel

 

[alexhu]

Seems to be 8.1.6 from the docs @

http://download-uk.oracle.com/docs/cd/A81042_01/DOC/index.htm

Alex