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 -> Re: NUMBER vs NUMBER (n)

Re: NUMBER vs NUMBER (n)

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Fri, 29 Sep 2006 19:41:06 -0700
Message-ID: <l4SdnUrm2tXVRIDYnZ2dnUVZ_v-dnZ2d@comcast.com> 






> 

> 2) For surrogate key, is it better to use INTEGER, or NUMBER or NUMBER

> (n) ? why ?

> 

> Thank you,

> xtanto




Neither - store surrogate keys in VARCHAR2 columns - typically you are 
unlikely to need to perform arithmetic on a surrogate key.
Received on Fri Sep 29 2006 - 21:41:06 CDT












Original text of this message













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