My impressions, since I work with both:

SQL Server has some nice features like DTS and the SQL Server Agent, much easier to configure than Oracle.

However, when properly used Oracle is quite more powerful. It seems the approach on 10g is to make the DB as easy as MSSQL.

The better choice falls on the obvious considerations of scalability, costs and sizing.