Re: LNNVL function

Richard Kuhler wrote:

> 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
>

Ok I'll bite.

Went to tahiti.oracle.com searched for LNNVL ... nothing. Went to google.com searched for LNNVL ... found only this thread Went to the data dictionary as SYS and ran: select count(*) from all_arguments
where object_name = 'LNNVL';
.. and found nothing.
Went to the data dictionary as SYS and ran: select count(*) from dba_objects
where object_name = 'LNNVL';
... and found nothing.
grepped every file in $ORACLE_HOME/rdbms/admin on 9.2.0.4 ... and found nothing.

And yet I can test the above and it works.

What is LNNVL and where is it documented?

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)