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: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?

Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?

From: <ctcgag_at_hotmail.com>
Date: 25 Nov 2002 02:32:06 GMT
Message-ID: <20021124213206.758$2o@newsreader.com>


"Jim Kennedy" <kennedy-family_at_attbi.com> wrote:
> a surrogate key is an arbitrary key (eg a sequence). A natural key is
> one that is naturally part of the data (eg in the US the social security
> number for people)
> Jim

There is nothing natural about the social security number. I think it's more a surrogate key which failed to maintain it's detachment.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB
Received on Sun Nov 24 2002 - 20:32:06 CST

Original text of this message

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