And then the lowest next available is 3 not 6. Incidentally nothing is said
that requires the sequence to increment by 1 either. It could be
10,20,30,40,50 ...
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
<rogergorden_at_gmail.com> wrote in message
news:1106583400.074931.31940_at_f14g2000cwb.googlegroups.com...
>I agree, there isn't any business purpose to do this.
> The requirement; as stated; says, "The
> business rule is that the system should have an option to assign the
> lowest
> next available Control Code for the new item created."
> Lowest, next available, is sequence folks. If you're multiuser, it's
> the way to go.
> If you really try hard to have 1,2,3,4 etc, and someone deletes a row,
> what will happen
> if you then have 1,2,4,5 etc?
>
Received on Mon Jan 24 2005 - 11:27:40 CST
