Skip to Main Content
Forums

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!

LEAD/LAG function with ignore NULLS gives warning in Oracle 11g

Anjali SharmaJan 13 2015 — edited Jan 27 2015

Hi,

In my query I am trying to use LEAD function with IGNORE NULLS option. The code is as below:

LEAD(COLUMN1 IGNORE NULLS)OVER(ORDER BY DATE_COLUMN DESC)

It gives a warning as: '[Error] Syntax check (4: 18): ERROR line 5, col 19, ending_line 5, ending_col 22, Found 'LEAD', Only FIRST_VALUE and LAST_VALUE are valid with IGNORE NULLS'

However when I run the query it works fine without any error. Why am i getting this warning?

My oracle version is; Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Thanks,

Anjali
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2015
Added on Jan 13 2015
#oracle
31 comments
14,644 views