Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> LNNVL function

LNNVL function

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Thu, 30 Oct 2003 17:23:27 +0000 (UTC)
Message-ID: <3FA1490E.C51D2C5@hotmail.com>


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? Received on Thu Oct 30 2003 - 11:23:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US