4 ms·
Far easier said than done. And that you mentioned MySQL/MariaDB as a possible replacement means that you have never worked with Oracle's SQL dialect.
by shrubble 3y ago
Far easier said than done. And that you mentioned MySQL/MariaDB as a possible replacement means that you have never worked with Oracle's SQL dialect.
- icedchai 3y agoOracle even has its own proprietary, alternate JOIN syntax. The devil is always in the details.
- robocat 3y agoEmpty strings "" being NULL was a hidden issue I remember causing problems.
- walrus01 3y agoDidn't say it would be easy - and indeed I'm well aware that Oracle is very different than MySQL. It's a painful transition process that more organizations will find necessary as the costs and hassle of oracle increase. If the end state goal is to have zero oracle in production use, people will have to figure out some kind of transition process to migrate away incrementally.
- Shorel 3y agoI have worked with Oracle and MySQL was the replacement. I rewrote the dozens of PL/SQL SP into the retarded language that MySQL has. It's not impossible in any way.
- evanelias 3y agoMariaDB has been improving Oracle compatibility in recent years, see https://mariadb.com/kb/en/sql_modeoracle/ https://mariadb.com/kb/en/sql_modeoracle/