Editor: Syntax error incorrectly reported for lag/lead analytic functions with ignore nulls inside the brackets


This has been an issue with Toad for a little while, and whilst it’s not a massive bug, I know it’s caused at least one person an issue. This picture demonstrates the issue:


Both queries are valid forms of LAG in 11.2 and above, and both run correctly; it’s just that Toad reports one as having a syntax issue. Oracle list both forms as acceptable: http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions082.htm#i1327527

Is there any chance of correcting this so that both of the above forms of the LAG and LEAD analytic functions show as syntactically correct?


This is fixed for next beta.

I have similar issue with ALTER SESSION statement.
A word PLSQL_CCFLAGS used for conditional compiling is recognized as an error.


I'm using the latest Toad for Oracle Xpert (64-bit)

Is there a way to add this word to some sort of ignore list?

Queued as QP-4127.

Thanks for reporting,

By the way, I wonder which of the parameters listed on Initialization Parameters could be used in an ALTER SESSION statement. The Oracle ALTER SESSION doc page is not very clear about that.

Is there anyone who could shed a light on this? Would be great!


Hi Andre,

They vary from one oracle version to another, but can be found by this SQL:

select distinct name
from v$parameter
where issys_modifiable <> 'FALSE';

Got it! Thanks John!

1 Like