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: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 13 Jun 2006 13:19:20 -0800
Message-ID: <448f1dc8$1@news.victoria.tc.ca>


g_chime_at_yahoo.com (g_chime_at_yahoo.com) wrote:
: I am converting from MySQL to ORACLE and having problems with an
: autoincrement field.
: MySQL has a built-in autoincrement feature ORACLE doesn't seem to.

The fact that oracle sequences are sequential numbers is just an (un)happy coincidence. They would actually have been better off to generate large very random numbers instead of sequential numbers because then noone would be confused as to how to use the result - i.e. as a unique index that has very little other meaning. Received on Tue Jun 13 2006 - 16:19:20 CDT

Original text of this message

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