Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help with no-gap autoincrement field
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
![]() |
![]() |