Re: 'null' values

In article <l.carl.pedersen-0803951721460001@kip-2-sn-470.dartmouth.edu> l.carl.pedersen@dartmouth.edu "L Carl Pedersen" writes: A digression from the original question but: : BOTH of these objects are treated like nulls, e.g., you : always get FALSE when you compare anything to a zero-length string, even : *another* zero-length string. Techinically you get NULL, Oracle works on 3-value logic: TRUE, FALSE, and NULL, so something that is not TRUE need not be FALSE. : I suspect that part of the reason they have never : fixed it is that it's been that way so long. But now the good news: Oracle are already issuing warnings (lurking somewhere in the manuals or in the README files) that in future releases they will not guarantee that NULL and '' will be considered identical. -- Jonathan Lewis