Re: Auto increment identity column?
From: Ken Denny <ken_at_kendenny.com>
Date: Thu, 25 Apr 2002 00:18:21 GMT
Message-ID: <Xns91FACF59DEABCkendenny_at_65.82.44.7>
Date: Thu, 25 Apr 2002 00:18:21 GMT
Message-ID: <Xns91FACF59DEABCkendenny_at_65.82.44.7>
mitra928_at_hotmail.com (mitra fatolahi) wrote in
news:4022442f.0204241551.59142921_at_posting.google.com:
> Does Oracle database has the Auto Increment identity column feature
Use a sequence. The syntax to create it is here:
http://www.ss64.demon.co.uk/ora/sequence_c.html
When you insert into the table, insert sequence_name.NEXTVAL into the
> like MS SQL Server? I want to use it as the Primary key for my table.
-- Ken Denny http://www.kendenny.com/ Taxation WITH representation isn't so hot, either!Received on Thu Apr 25 2002 - 02:18:21 CEST