Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> What's the equivalent of "identity"(ms sql) in oracle?
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