Re: one more newbie ? - autonumber?

jbaldner wrote:

> Perform a DMAX function on the field in question, then add 1 to
> that value
>
> --
> Posted via dBforums
> http://dbforums.com

This is no way to number things in Oracle as it forces serialization. Performance and scalability takes a huge hit.

This should be done with a sequence and, likely, a before insert trigger.

Daniel Morgan Received on Fri May 31 2002 - 10:20:15 CDT