Oracle has sequences where MSSQL has identities.

Don't expect to define a table in Oracle to have an auto-incrementing numeric field. Instead one specifies an integer field and then has to hand in some sequence syntax whenever one writes to the column in the name of making a number count upwards.