Re: where clause

  • From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 6 Feb 2004 15:19:16 -0500

On 02/06/2004 03:07:41 PM, Wolfgang Breitling wrote:
> NULL is NULL. It is not equal anything and it is not unequal  
> anything.
> It
> is just NULL
>

Actually, I've noticed that many people have problems with
ternary logic, where condition can be false, true and null.
I'd put every relational database designer thru a course
of the Zermelo-Frankel set theory. I know that relational
databases are based on naive set theory (Cantor's theory)
but Z-F with "axiom of choice" would teach them to excercise
unusual way of thinking. It would very interesting to see the
results and reactions.....
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: