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: DFS <nospam_at_dfs_.com>
Date: Fri, 19 Aug 2005 08:43:46 -0400
Message-ID: <5ukNe.1461$1g2.1170@fe05.lga>


sim wrote:
> You already sait it: It's just a matter of taste. I'd prefer different
> sequences because I don't like the IDs being out of order. On the
> other hand I try to avoid the usage of sequences anyway because I
> hate it that there a gaps in the IDs when I delete rows and insert
> new ones.

I know what you mean, actually. Even though it's totally irrelevant, I like having sequential IDs.

Freud has a 4-digit term for this.

> Jörg
Received on Fri Aug 19 2005 - 07:43:46 CDT

Original text of this message

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