Rob Cowell wrote:
> Anyone got any ideas.
>
> SELECT 1 FROM DUAL
> WHERE LNNVL(1=2)
>
> returns
>
> 1
>
> Suggesting that LNNVL(1=2) evaluates to true
>
> But LNNVL(1=1) evaluates to false
>
> I assume there must be some NULL processing going on too because of the
> function name.
>
> It seems totally undocumented and there's only one unhelpful mention on
> Metalink.
>
> Anyone know for sure what it does?
I found a google reference that seems to be correct. It's 'Logic Not
NVL'. So it negates the boolean result but returns true for null.
However, being undocumented, I'd stick with something like 1!=2 or 1 is
null or 2 is null.
--
Richard Kuhler
Received on Thu Oct 30 2003 - 14:21:14 CST
