What are the major differences between the mysql and oracle sql dialects?

Question

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.

question from:https://stackoverflow.com/questions/7283828/what-are-the-major-differences-between-the-mysql-and-oracle-sql-dialects

Answer 1

For example I was told that oracle as no auto increment.

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.