0

Good afternoon,

Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords?

The reason I ask, is I'm planning to use MySQL WorkBench to generate the SQL for Oracle 10g. If you'd recommend a different ERD modelling tool, please suggest one that can be generated from text.

Thanks for all suggestions,

Alec Taylor

1 Answer 1

2

There are big differences between the two. The datatypes are different (e.g. Oracle doesn't have the ENGINE part, int(5) is invalid for Oracle, LONGTEXT is invalid for Oracle and so on) and part of the syntax as well. Oracle does not have an "autoincrement" column. It has a different concept using sequences.

If you want to find all the differences you will have to read the manuals and compare for yourself

If MySQL Workbench emits only MySQL syntax you will need some manual search & replace to convert that to valid Oracle SQL but it is certainly doable.

2
  • Thanks, sounds like a lot of work, maybe I should look at a different ER Modelling tool...
    – A T
    Commented Sep 17, 2011 at 9:58
  • I've decided to write the SQL by hand, and generate a diagram from that using SchemaSpy
    – A T
    Commented Sep 19, 2011 at 11:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.