Re: Oracle NULL vs '' revisited

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1187911246.647202_at_bubbleator.drizzle.com...
> Tony Rogerson wrote:
>>> 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;
>
> That statement just earned you a place in my class at the university.
> Would you like to reconsider it before you earn a place of infamy?
> Natural keys can not change. If it can change IT IS NOT A KEY it is
> just a value.
>
> Good grief!
>
>> 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.
>
> Look who's talking. And while you are reconsidering, and you should,
> your response to Ed consider this:
>
> ID FNAME LNAME
> 1 Daniel Morgan
> 2 Jack Cline
> 3 Daniel Morgan
>
> That surrogate key accomplished precisely what?
>
> Amazing!
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Good example! Two Daniel Morgans MUST be a TERRIBLE bug in the system <g>

Shakespeare Received on Fri Aug 24 2007 - 04:18:58 CDT