Some ways Oracle is different from MSSQL...

1. Dates are very different, but otherwise most of the heavy differences are "deep down."
2. There is not bit type. Use a 1 or a 0 at an integer type to express true/false.
3. There is no way to wrap the creation of tables in transactions.
4. Oracle is "better" at concurrency and scenarios involving millions of records.