Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited
> 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