Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does oracle have an auto increment column

Re: Does oracle have an auto increment column

From: Bill Bearden <bbearden_at_bcl.net>
Date: 6 Jun 98 19:20:38 GMT
Message-ID: <01bd9180$9ebbef80$9abccecf@bbearden>


Having started out on SQL Server, this is one feature (there aren't many) I do miss in Oracle. In SQL Server, it is called an INDEX column. Sequences in Oracle perform a similar function but they aren't automatic. Every programmer and every program inserting a row in a table must know to fill in the PK column with the NEXTVAL of the sequence.

Bill Bearden

Dennis JR Harding <dennish_at_wpr.co.za> wrote in article <6l85tj$847$1_at_news01.iafrica.com>... <<stuff deleted>> Received on Sat Jun 06 1998 - 14:20:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US