Hacker News new | ask | show | jobs
by michielr 3324 days ago
When running with sql_mode=ORACLE, the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. See MDEV-10142, MDEV-10764 and MariaDB-10.3.0 release notes to know the current status.

So after the update you can use a (subset) of pl/sql.
2 comments
SOLAR_FIELDS 3324 days ago
Nice. This really is a shot at Oracle's hegemony when it comes to enterprise databases.

Has anyone here done a migration from Oracle's offering to MariaDB? How difficult was it?

link
thorin 3323 days ago
That's what I was expecting to see but I couldn't find in your post. Thanks for the clarification. Would be good to see a similar mode in postgres as I know pgsql is close, transpilation makes stored procs cool!
link