Re: IDENTITY property (MS SQL Server code port)

iarld_at_connectnet.com (Lee Doty) wrote:

>The Identity property is a MS declarative constraint that makes the
>specified column automaticly take the next available value. This was
>too tempting to resist using for many of our primary keys. We have
>perhaps 200 tables with the identity property on their primary keys,
>and multiples of that number of points in our code where we are
>inserting into those tables (and therefore not specifying a primary
>key).
 

>Our problem is that we cannot find an equivolent functionality with
>Oracle 7.3 Workgroup Server.
 

>I understand that I could write about 200 Before Triggers to furnish
>these values, but this seems like an option of last resort, due to the
>size and tediousness of the task, as well as concerns about the
>efficiency of such a solution.

Sequences are the Oracle equivalent. You won't need insert triggers. Just use the nextval of the sequence in your insert statement.

Mike White
The Image Consulting Group
mwhite_at_icgconsulting.com Received on Wed Jun 11 1997 - 00:00:00 CDT