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: Please help with no-gap autoincrement field

Re: Please help with no-gap autoincrement field

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 13 Jun 2006 22:09:20 +0200
Message-ID: <iq6u82poekpsmiamo1vc6k42ujvqna01eq@4ax.com> 





On 13 Jun 2006 09:54:41 -0700, "g_chime_at_yahoo.com" <g_chime_at_yahoo.com>
wrote:



>

>The problem is that when an insert fails the sequence still increments,

>so there will be gaps.

>This is a data warehouse and rows are never deleted, and the

>autoincrement field should have no gaps.




For the sake of beauty? Or for what other purpose that helps gaining
money?


--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jun 13 2006 - 15:09:20 CDT












Original text of this message













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