SQL Question - Identity columns

Hello,

I'm new to Oracle but I have several years of experience with Microsoft SQL Server.

In SQL Server there is a column type called IDENTITY. Basically this is a numeric column that is automatically assigned the next highest number each time a row is inserted into the table (i.e. first column gets a 1, next column gets a 2, etc). I use it extensively for creating primary keys.

Does Oracle's SQL language have the equivalent? If not, what's the best way to simulate the same behavior?

Thanks. Received on Mon Nov 20 2000 - 18:50:20 CST