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 -> How long is long enough for primary key ?

How long is long enough for primary key ?

From: <krislioe_at_gmail.com>
Date: 6 Oct 2006 20:07:57 -0700
Message-ID: <1160190476.986942.92990@i42g2000cwa.googlegroups.com>


Hi,

In our design, lookup tables (Customers, Products etc..) are using natural key as PK. We use VARCHAR2(30) as PK column.

Is it too long ? How long is too long ?

Thank you,
xtanto Received on Fri Oct 06 2006 - 22:07:57 CDT

Original text of this message

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