Malcolm Dew-Jones wrote:
> 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.
>
And in a data warehouse you are probably better of using a random
character string than a random number (or even a number stored as a
character string)
Received on Tue Jun 13 2006 - 21:15:34 CDT
