mysql 和 oracle sql 方言之间的主要区别是什么？
我是一名软件开发人员。我已经使用mysql很多年了，现在我即将在项目中第一次遇到oracle。
我只是被告知我应该小心，在某些情况下 sql 的行为完全不同。我不知道会发生什么。我主要寻找明显的东西和典型的初学者错误。
例如，有人告诉我，oracle 没有自动增量。
这就是我正在寻找的东西类型。我将不胜感激任何有助于避免为已解决的问题创建新解决方案的进一步知识。
I am a software developer. I have used mysql for years and now I am about to have my first encounter with oracle in a project.
I was just told that I should be careful that the sql behaves quite differently in some cases. I have no idea what to expect. I am mostly looking for obvious stuff and typical beginner mistakes.
For example I was told that oracle as no auto increment.
That's the type of stuff I am looking for. I'd be grateful for any further knowledge that helps avoid creating new solutions to problems already solved.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Oracle 有序列；这只是一种不同的符号。在 INSERT 时自动递增列值的想法确实存在。
Oracle 会让您添加主键和外键作为约束，与表定义分开。
PostgreSQL是开源数据库中最接近Oracle的。它也有顺序。
Oracle has sequences; it's just a different notation. The idea of a column value that's automatically incremented on INSERT is certainly there.
Oracle will have you add primary and foreign keys as constraints, separate from the table definition.
PostgreSQL is the closest thing to Oracle among the open source databases. It, too, has sequences.
分组是一个主要区别，因为 MySQL 对分组有自己的非标准解释。因此，如果您使用大量巧妙的分组，您可能会发现 Oracle 将不会执行您的查询。
http://dev.mysql.com/doc /refman/5.6/en/group-by-hidden-columns.html
Grouping is a major difference, as MySQL has its own non-standard interpretation of grouping. So if you're using a lot of clever grouping, you might find that Oracle will not execute your queries.
http://dev.mysql.com/doc/refman/5.6/en/group-by-hidden-columns.html