Wolfgang Weisselberg writes: > On Mon, Dec 03, 2001 at 14:36:19 -0600, Stephen Clouse wrote: > > > A common way of leveraging this in Oracle is for atomic check-and-insert > > operations using a primary key. Visualize two transactions writing some > > unique rows to a table. > > I thought that was why you use sequences...
Sure. But there are valid reasons for having additional unique indexes or constraints. Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com