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 -> What's the equivalent of "identity"(ms sql) in oracle?

What's the equivalent of "identity"(ms sql) in oracle?

From: Pauline Ohanian <pauline_at_isol.com.lb>
Date: Tue, 08 Dec 1998 17:03:45 GMT
Message-ID: <366D5B09.2B65419C@isol.com.lb>


hi,
I want to know how to make a field in a table an autoincrement field. With MS SQL, you just define the field as "identity" and whenever you insert a record,
you don't insert any value for this field and automatically this field will get the value of the
last record field value + 1. How can I do this in Oracle?

Thanks in advance,
Pauline Received on Tue Dec 08 1998 - 11:03:45 CST

Original text of this message

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