Re: help with join

From: Root <root_at_aol.com>
Date: Thu, 29 Jul 2004 00:55:20 GMT
Message-ID: <YVXNc.99439$Zk4.84819@newssvr29.news.prodigy.com>

"Bricklen" <bricklen-rem_at_yahoo.comz> wrote in message news:fOTNc.114309$Rf.6656_at_edtnps84...
> Root wrote:
> <snip>
> > nvl takes two arguments, returns the first if they are not equal?
> >
> no, it can expressed like this:
>
> If the first value listed IS NULL, then use the second listed value.
>
> NULL does not evaluate to anyting, it's unknown, so cannot be EQUAL to
> anything.
>
> The oracle docs are at tahiti.oracle.com
>
>

Thanks!! Received on Wed Jul 28 2004 - 19:55:20 CDT