Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 24 Aug 2007 10:50:01 -0700
Message-ID: <1187977798.50878@bubbleator.drizzle.com>


Tony Rogerson wrote:

> 

>> ID FNAME LNAME
>> 1 Daniel Morgan
>> 2 Jack Cline
>> 3 Daniel Morgan
>>
>> That surrogate key accomplished precisely what?
>
> And where is your natural key?

The point was to demonstrate the surrogate keys are worthless for purposes of data integrity with most data. What ends up happening is that unique constraints are then built, on top of the surrogate key, in an attempt to do what the surrogate can not.

-- 
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
Received on Fri Aug 24 2007 - 12:50:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US