Home » SQL & PL/SQL » SQL & PL/SQL » ORA-30484: missing window specification for this function (oracle10g)
ORA-30484: missing window specification for this function [message #317333] Wed, 30 April 2008 09:11 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

i have executed a simple query it shows error like ORA-30484: missing window specification for this function

select department_id,lag(department_id,1),over(order by department_id)
from employees
where department_id in 102845.

How can resolve this issue?

Thanks,
Michael
Re: ORA-30484: missing window specification for this function [message #317334 is a reply to message #317333] Wed, 30 April 2008 09:14 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"," too much before "over".

Regards
Michel
Previous Topic: how to alter the blocksize value ?
Next Topic: not null column count (merged 2)
Goto Forum:
  


Current Time: Wed Dec 07 14:38:29 CST 2016

Total time taken to generate the page: 0.16623 seconds