Re: Auto increment identity column?
From: Oneil <oneill_at_hotmail.com>
Date: 25 Apr 2002 13:03:41 -0700
Message-ID: <2a1f66da.0204251203.2d190e02_at_posting.google.com>
Date: 25 Apr 2002 13:03:41 -0700
Message-ID: <2a1f66da.0204251203.2d190e02_at_posting.google.com>
mitra928_at_hotmail.com (mitra fatolahi) wrote in message news:<4022442f.0204241551.59142921_at_posting.google.com>...
> Does Oracle database has the Auto Increment identity column feature
> like MS SQL Server? I want to use it as the Primary key for my table.
>
> Thanks,
> Mitra
Use a sequence number generator in conjunction with a Before Insert trigger to put a unique value in the field. Received on Thu Apr 25 2002 - 22:03:41 CEST