Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?
"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 50GBReceived on Sun Nov 24 2002 - 20:32:06 CST