Re: LNNVL function

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Thu, 30 Oct 2003 17:59:40 +0000 (UTC)
Message-ID: <3FA1518B.DE0D964C@hotmail.com>

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?

Before I get flamed, this is on 8.1.7.4 Received on Thu Oct 30 2003 - 11:59:40 CST