Re: Default column value of MAX +1 of column - possible in Oracle 9i?

its simple only because you think of it in terms of a single user system.
I believe that you need to read the concepts guide (http://tahiti.oracle.com)and check out the AskTom site at http://asktom.oracle.com.
You need to understand concurrency and transaction control.

How could multiple users possibly have transactions against this table and not have a race condition or collision?

single user MS Access database, your approach select max(ID) + 1 sounds adequate.
multi-user database ... use the sequence/insert trigger approach, that's what its there for.

good luck.

-bdbafh Received on Thu Mar 24 2005 - 12:54:47 CST