Here is an example of something that is easier to do in SQL server than in Oracle:
Autoincrement primary key for Oracle