MySQL 和 Oracle DB 之间的差异
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4954076/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Differences between MySQL and Oracle DB
提问by Jungle Hunter
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.
MySQL 和 Oracle 11g 之间有什么区别 - 特性和性能？在特定情况下，我希望能够在两者之间做出明智的选择。
Note:Links to test will obviously help.
注意：测试链接显然会有所帮助。
采纳答案by a_horse_with_no_name
Things that MySQL is still lacking (that Oracle has)
MySQL 仍然缺乏的东西（Oracle 有的）
- 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
- 可延迟约束
- 检查约束
- 递归查询
- 表函数
- 公用表表达式
- 窗口函数
- 基于函数的索引
- 部分索引
- 没有 MINUS（或 INTERSECT）运算符
- 当涉及到子选择时，非常简单的查询优化器
- 很多非标准语法（|| 是逻辑或！）
- 没有闪回
回答by ThinkJet
Very popular answer for StackOverflow:
StackOverflow 非常流行的答案：
看看维基百科！:)
Another useful place to look for SQL features comparation:
另一个寻找 SQL 特性比较的有用的地方：
Comparison of different SQL implementationsby Troels.
Hope, you can find answers here ...
希望你能在这里找到答案......
回答by paxdiablo
Apparently, MySQL can tell the difference between an empty VARCHAR and a NULL value:-)
显然，MySQL 可以区分空的 VARCHAR 和 NULL 值:-)
That alone is enough for me to avoid Oracle.
仅此一项就足以让我避免使用 Oracle。
