Differences between MySQL and Oracle DB [closed]

Question

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.

Answer 1

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

Answer 2

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 ...