I recently started exploring sql basics in oracle to help myself to work on a migration project where project is subject to migrate from Oracle platform to a different one; while trying to google for a concept, say for instance, on-delete and on-update clauses and actions, the result has web-links for mysql and oralce-sql; what concerns me here is whether to consider mysql and oracle documentation for interpretation, and sometimes mysql documentation got a better explanation and hence I fell into dilemma.
would anyone please comment on my concern.
Thank you for giving your valuable time and knowledge.
Oracle <> MySQL.
Although some things work the same way and share the same syntax, you can't rely on one database's documentation presuming that it can be applied to another.
Also, maybe you were mislead by the fact that Oracle owns MySQL so both databases' documentation links look similar (docs.oracle.com/...).
Therefore, similar: yes, but same: no.