Question 348526 in Mysql Question posted in
The official MySQL documentation can be found here.

is the documentation for oracle-sql and mysql the same with respect to the definitions, syntaxes and rules?

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.

Tags:

2

Answers


  1. 0

    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.

    Login or Signup to reply.
  2. 0

    No, the documentation for Oracle SQL and MySQL are not the same with respect to definitions, syntaxes, and rules. While both Oracle SQL and MySQL are relational database management systems (RDBMS) that use SQL (Structured Query Language) as their primary language for querying and managing data, there are differences between the two in terms of syntax, features, and supported functionalities.

    Here are some key differences:

    Syntax Differences: While both Oracle SQL and MySQL support standard SQL syntax, they also have their own extensions and variations. Certain SQL queries or functions that work in Oracle may not work the same way in MySQL, and vice versa.

Data Types: Oracle and MySQL have some differences in the data types they support and the way they handle data. For example, Oracle supports a wider range of data types compared to MySQL.

Functions and Features: Each database system has its own set of built-in functions and features. While many functions may have similar names and purposes, their implementations and behaviors might differ between Oracle SQL and MySQL.

Stored Procedures and Triggers: Oracle and MySQL have differences in their support for stored procedures, triggers, and other procedural extensions to SQL.

Performance Optimization and Indexing: The methods for optimizing performance and creating indexes can vary between Oracle SQL and MySQL.

SQL Dialects: While both databases follow the SQL standard to a certain extent, they also have their own SQL dialects with specific syntax and behavior differences.

Documentation: Each database system has its own official documentation that covers the specifics of its SQL implementation, including syntax, rules, and best practices. Oracle SQL documentation is provided by Oracle Corporation, while MySQL documentation is provided by Oracle (after their acquisition of MySQL AB).

    It’s important to refer to the respective documentation for Oracle SQL and MySQL when working with each database system to ensure accurate syntax and behavior. While there may be some overlap in concepts and basic SQL syntax, the specifics can differ significantly between the two systems.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search