SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LAG function error

446118Aug 30 2006 — edited Aug 30 2006

I trying to get the row above p1.volume coloumn for the code below but i'm getting ORA - 30484 error - missing windows specification for this function. Please advise

code

SELECT p1.por_calc_holdings_ref ,p1.volume, LAG(p1.VOLUME,1,0)

FROM scdat.a_pfcholdings p1

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2006

Added on Aug 30 2006

2 comments

1,033 views