Tag Archives: plpgsql

Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration

Posted on May 3, 2024 by Deepak Mahto

Introduction – Implicit Conversion Oracle to PostgreSQL migration is a playground that uncovers and touches upon many database concepts, which are always intriguing and fun to explore. Implicit Conversion, i.e., imposing automatic conversion on data types to make them comparable … Continue reading →

Rate this:

Posted in Oracle to PG migration, postgresql | Tagged , , , , , , , , , | Leave a comment

PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.

Posted on April 23, 2024 by Deepak Mahto

If you’re fascinated by the internals of PL/pgSQL processing and want to handle it efficiently, especially if you’re migrating procedural logic from another database, be sure to check out the previous posts in the series on PL/pgSQL Conversion Gotchas – … Continue reading →

Rate this:

Posted in postgresql | Tagged , , , , , , | Leave a comment

PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.

Posted on April 12, 2024 by Deepak Mahto

Databases Cursors are one of the key components of development. We have been using them for traversing query results for processing based on business logic or functionality. In Code Conversion, Cursor code always needs to be ported either from PL\SQL … Continue reading →

Rate this:

Posted in Oracle to PG migration, postgresql | Tagged , , , , , , , , , | 1 Comment