"Ever since version 10.3, MariaDB has been steadily adding Oracle compatibility features, making it easier to port Oracle to MariaDB as-is. Oracle compatibility is opt-in. All you need to do is issue the command SET SQL_MODE='ORACLE' to activate it for a given set of SQL statements. Existing MariaDB behaviors will also be preserved wherever possible."
"Most Oracle compatibility features are geared to supporting Oracle SQL syntax, especially where it deviates from ANSI SQL or MariaDB. For instance, Oracle SQL allows you to call stored procedures using the name of the stored procedure rather than the CALL keyword. But other recent changes to Oracle compatibility mode involve underlying behaviors, not just syntax."
"As of MariaDB 12.0, single triggers can execute on multiple INSERT/ UPDATE/ DELETE events, an Oracle SQL feature that's difficult to replicate manually. MariaDB (the company) also offers a migration tool that analyzes an Oracle SQL DDL export file and assesses how well it will run with MariaDB's Oracle compatibility mode."
MariaDB, originally a MySQL fork created after Oracle's acquisition, has developed into an independent database system with distinctive features. Since version 10.3, MariaDB has progressively incorporated Oracle compatibility through an opt-in SQL_MODE setting, enabling direct migration of Oracle databases with minimal modification. The compatibility extends beyond syntax to include behavioral features like multi-event triggers. MariaDB 12.0 and later versions support advanced capabilities including native vector data types and AI integration through MCP servers. The company provides migration tools to analyze Oracle DDL exports and assess MariaDB compatibility, facilitating enterprise transitions from Oracle SQL environments.
Read at InfoWorld
Unable to calculate read time
Collection
[
|
...
]