Oracle Insights

Uncovering the Differences: Implicit Conversion in Oracle vs. PostgreSQL Migrations

Explore the challenges of implicit conversion when migrating from Oracle to PostgreSQL, and discover solutions to ensure seamless data handling.

Mastering PL/pgSQL: Navigating Functions with Out Parameters and Return Types

Explore the intricacies of migrating Oracle functions with out parameters and return types to PostgreSQL using PL/pgSQL, uncovering key considerations for seamless code conversion.

PL/pgSQL Conversion Gotchas: Cursors and Last Fetch

Deepak Mahto, a database expert, explores the nuances of cursor handling and the differences between Oracle's PLSQL and PostgreSQL's PL/pgSQL when converting code.