Re: SQL IF

From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/06/14
Message-ID: <LzM15.111$p62.48322_at_wdc-read-01.qwest.net>#1/1

[Quoted] By definition, NULL is "unknown." It isn't that Oracle doesn't "know what to do with it," but an unknown cannot be compared to a known value. Nor can you say that two unknowns are equal. Maybe they are; maybe they're not.

The NVL function allows you to state an assumption about what the unknown value is.

"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:skduqnniis493_at_corp.supernews.com...
> "Jack Ostroff" <jack_h_ostroff_at_groton.pfizer.com> wrote in message
> news:394651B4.681C4226_at_groton.pfizer.com...
> >Other readers have pointed out that NULL fails both = and <> tests.
>
> Yes. Oracle decides to treat nulls as "I don't know what to do with it"
in
> these kinds of tests. It's kinda annoying but I can sort of understand
why.
>
> -Matt
>
>
Received on Wed Jun 14 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Matt B.: "Re: SQL IF"
Previous message: bosimon_at_my-deja.com: "Re: Forms 6 help"
Maybe in reply to: Christina: "Re: SQL IF"
In reply to Matt B.: "Re: SQL IF"
Next in thread: Matt B.: "Re: SQL IF"
Reply: Matt B.: "Re: SQL IF"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message