Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Many companies have a heavy influence on market and technologies around them, and you often compare the products before you choose, e. g. I liked Oracle APEX, its flexibility and features, and we're using it production, however it requires Oracle Database (at least Express Edition), thus we had to install the latter.

I would like to know what are noticeable features Microsoft SQL Server can suggest and Oracle Database cannot, and vice versa; I imply the last versions of both products, because I've recently been told that Microsoft has left Oracle behind since 2005, and they (Oracle) should really think over it (maybe he was just payed).

I've consulted Comparison of relational database management systems on Wikipedia, but on the surface their feature sets don't seem to differ much.

I suppose the order with the most important features on the top is reasonable.

Thank you.

share|improve this question

closed as off-topic by Justin Cave, Paul White, RolandoMySQLDBA, Phil, Max Vernon Aug 6 '14 at 23:05

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Justin Cave, Paul White, RolandoMySQLDBA, Phil, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

Best we can collect some or many links to such comparisons. – bernd_k Jan 5 '11 at 13:39

You might want to look at what features you need or want, then make a decision on which platform. Do a little reading on each product and see what interests you, then see if the other supports the same thing, or something similar.

To me, since they both support the same core features, price will determine route, unless there's something in the other product that I couldn't live without. That being said, I would go with SQL Server the vast majority of the time as it continuously wins on price. A lot of other technologies (SSRS, SSAS, SSIS, etc) come bundled with SQL Server for free. Similar offerings from Oracle usually cost extra.

Yes this is a biased answer, but I enjoy the product and would recommend it to anyone looking for a db platform.

share|improve this answer

Let us focus on some differences.

Oracle has no temporary tables or table variables. Oracles so called global temporary tables are predefined database objects of fixed structure. They are definitely something different.

When working with cursors you need one variable which represents a record as opposed to endless declare lists for each single field in the result set.

Oracles varchar2 datatype has a maximal width of 4000 chars as opposed to around 2GB of varchar(max) (SQL-Server 2008).

SQL-Servers makes it much easier to work with case insensitive varchars.

In SQL-Server you have little problem in returning result sets, while Orcale requires that you understand a concept called ref cursors.

In SQL-Server you have 2 layers SQL and TSQL. in Oracle you have 3 layers SQL, PLSQL and sqlplus which all contribute to syntactical differences.

share|improve this answer
This topic in the Meta (…) treats this problem of the type of questions asked here and I see that feature comparisons are allowed. So we should help and answer preferably :). – Marian Jan 19 '11 at 19:35
@berbd_k your last point is incorrect - sqlplus is a command line SQL query tool much like isql – Kevin Walz Feb 11 at 14:35

If you're looking at core feature comparisons, there aren't going to be a lot of differences between the two. Oracle has better support for the windowing functions and maybe a few other things. They both support hosting an application language (PL/Java vs SQL CLR). The feature differences become more pronounced when you start looking at offerings above the standard edition.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.