Re: Oracle NULL vs '' revisited

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.

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