Using Regular Expressions To Convert Oracle PL/SQL Stored Procedures to Postgres PL/PGSQL

We all know that there will eventually come a time when a major decision has been made to change databases. When a lot of custom SQL code has been written for the old database, which needs to be converted to the new one — and this is true especially when stored procedures are used a lot — , automated programs and regular expressions can be a speedy and efficient way to get the job done.

In this article, I will go through some main SQL syntax differences between Oracle PL/SQL and…