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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Primary Key of type string ?

Re: Primary Key of type string ?

From: <sybrandb_at_hccnet.nl>
Date: Thu, 31 May 2007 17:48:00 +0200
Message-ID: <ldrt53168ei4fl9epvqaok87aj12rlnke3@4ax.com>


On Thu, 31 May 2007 13:41:01 +0200, Robert Klemme <shortcutter_at_googlemail.com> wrote:

>And I thought the standard choice would be the key dictated by business
>requirements...

Question: do you like to have composite, possible lengthy foreign keys in all of your tables?
One usually ends up with a surrogate key. And NO those shouldn't be varchar2(31)
(Regrettably this is a real world example in a commercial application).

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu May 31 2007 - 10:48:00 CDT

Original text of this message

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