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