Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jun 22 20:04:14 CDT 2009
There are many reasons to avoid Oracle , not the least being the complex requirements to installing the ODBC driver for a specific Oracle version. But I call B*llsh*t on this! The writer knows not of what he speaks! Concatenation is not a binary operation. SQL Server and Access both operate in the same way as this with Nulls. -- Stuart On 23 Jun 2009 at 9:13, Darryl Collins wrote: > For example: > > "Though common sense leads us to conclusion that a basket with one > apple is clearly different from a basket without apples, in Oracle > they are not different. > > So the empty basket is not different from a non-empty one, but then > again, they are also not the same. Putting all that in one sentence, > the empty is not equal to anything, nor different from anything, > including nothing. It is a bit painful, isn't it? > > In theory, any binary operation involving NULL will also give NULL, > but even that is not consistent. Add NULL to 1 and you will get NULL, > but concatenate NULL to 'Donald' and you will get 'Donald'. NULL and > empty string, as far as Oracle is concerned, are the same (but then > again, not equal).