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: VARCHAR as primary key

Re: VARCHAR as primary key

From: <markp7832_at_my-deja.com>
Date: Tue, 22 Feb 2000 18:57:26 GMT
Message-ID: <88um6j$bt0$1@nnrp1.deja.com>


In article <88u5ma$ut4$1_at_nnrp1.deja.com>,   b_aggy_at_hotmail.com wrote:
> HI people,
>
> Is there any issue behind using columns of type varchar2 as primary
> keys.
> Does this have any impact on the primary index.
>

We use varchar2 as primary and unique keys more often than we use numberics. It just makes business sense to use the natural keys that exist within the business line.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 12:57:26 CST

Original text of this message

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