Differences between MySQL and Oracle DB [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. 开发者_Go百科 Closed 12 years ago.

What are the differences - features and performance - between MySQL and Oracle 11g? I would like to be able to make and educated choice between the two given a situation.

Note: Links to test will obviously help.

---

Things that MySQL is still lacking (that Oracle has)

• deferrable constraints
• check constraints
• recursive queries
• table functions
• common table expressions
• windowing functions
• function based index
• partial index
• No MINUS (or INTERSECT) operator
• very simple query optimizer when it comes to sub-selects
• A lot of non-standard Syntax (|| is a logical or!)
• no flashback

---

Very popular answer for StackOverflow:

Look at Wikipedia! :)

Another useful place to look for SQL features comparation:

Comparison of different SQL implementations by Troels.

Hope, you can find answers here ...

---

Apparently, MySQL can tell the difference between an empty VARCHAR and a NULL value :-)

That alone is enough for me to avoid Oracle.