hpuxrac wrote:
> Ok now I see the OP "but want to insert numbers in ascending order".
>
> Before considering and suggesting the ORDER clause for a sequence as an
> oracle implementation, my recommendation would be to ask "what exactly
> does the business application require" to meet the "ascending order"
> part.
>
> I don't think the OP supplied enough information to make more than
> guesses at this point.
I agree and believe I questioned the business rule. I don't think
the OP ever responded.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Nov 16 2005 - 00:13:01 CST
