[AccessD] Learning .Net

Darryl Collins Darryl.Collins at coles.com.au
Mon Jun 22 20:37:27 CDT 2009


Hi Stuart

I would agree with the Concatenation result as a bit of a beat up - I would expect the result he got from any system, but I have heard that the way Oracle deals with Nulls is not easy to grasp and is different to SQL Server.  I don't know enough about this to really comment directly but I it would be interesting to hear what other folks have had in experience with this think.  I know a lot of folks I work with really dislike Oracle.  Biased? maybe, but then maybe not.

cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, 23 June 2009 11:04 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Learning .Net

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). 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.





More information about the AccessD mailing list