Re: Oracle NULL vs '' revisited

From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Thu, 23 Aug 2007 22:37:45 +0100
Message-ID: <fakupc$prl$1$8302bc10@news.demon.co.uk>

> Ah, that is why you like those so much Tony. You are forced to use a
> crutch and have grown to like it. You have my deepest sympathies.

Unlike yourself Ed I realise the natural key may change; and unlike yourself Ed I prefer to protect myself from the concurrency problem caused by a disconnected application archiecture - basically, the web broweser as an example; surrogate keys are a known, tried and tested solution for that.

That class room door you hide behind needs oiling.

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

Received on Thu Aug 23 2007 - 16:37:45 CDT