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

setup a sequence field ...

daniel...

Pauline Ohanian wrote in message <366D5B09.2B65419C_at_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:18:03 CST