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

mysql sql oracle dialect
Yashima picture Yashima · Sep 2, 2011 · Viewed 85.7k times · Source

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.

Answer

duffymo picture duffymo · Sep 2, 2011

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.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) values: id | item | price ------------- 10 | book | 20 20 | book | 30 Now I want to: update table1 set table1.Price = table2.price where table1.…

Read More