0

Is the syntax of Oracle10g and mysql are the same? For example the select query? Thanks, I'm using MySQL and want to try Oracle 10g for my java.

3
  • There are way too many differences. But don't use Oracle 10g, it's out of support since a few years, go for 12c (or maybe 11gR2)
    – dnoeth
    Apr 14, 2016 at 8:07
  • From your link "However MySQL silently ignores the CHECK constraint" is enough. No CTEs or windowing (analytic) functions.... I could go on. MySQL is a lucky toy. PostgreSQL is a real industrial standard RDBMS. You are correct though - it's up to DBA/devs to choose.
    – Vérace
    Apr 14, 2016 at 8:28
  • Maybe 70% of the lines of SQL will be 'compatible'. Expecting portability of SQL is folly.
    – Rick James
    Apr 14, 2016 at 17:23

1 Answer 1

1

They're vastly different when it comes to other features, such as security, programming languages, data types, tools, end user support, requirements, etc.

However, they're both compliant with basic SQL92 (and perhaps other SQL standards), so one can do the same basic schema creation and data querying and manipulation. You should be able to do the basics from java applications without noticing where you're connected to (and this applies to several other databases).

1
  • In limiting yourself to the standard, you must forgo various extensions, some of which are significant performance improvements.
    – Rick James
    Apr 14, 2016 at 17:24

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.