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: One sequence per table?

Re: One sequence per table?

From: <sybrandb_at_yahoo.com>
Date: 19 Aug 2005 04:08:22 -0700
Message-ID: <1124449702.716116.220480@o13g2000cwo.googlegroups.com> 





You use sequences for surrogate keys. The value of the key is
meaningless.


Consequently, gaps are irrelevant.


Are you sure you understand what sequences are and when to use them?


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Fri Aug 19 2005 - 06:08:22 CDT












Original text of this message













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