The differences is given below:-
1.Transaction control:- In Oracle EVERYTHING is a transaction and it is not permanent until you COMMIT. In SQL Server, there is (by default) no transaction control.
2.MVCC. In SQL Server and Oracle is different. SQL Server will allow dirty reads, and writes can block reads in MS SQL,unlike Oracle where read consistency is default and unbendable.