PL/pgSQL — 2 Technical Articles

Sep 5, 2025 · Databases

How to Migrate Oracle Stored Procedures to PostgreSQL with Minimal Tweaks

This guide walks you through preparing Oracle and PostgreSQL test tables, inserting sample data, converting an Oracle stored procedure to PostgreSQL using the SQLShift tool, and fixing the few manual adjustments needed for a successful migration.

OraclePL/pgSQLSQL tutorial

0 likes · 19 min read

How to Migrate Oracle Stored Procedures to PostgreSQL with Minimal Tweaks

Big Data Technology & Architecture

Dec 28, 2020 · Big Data

Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL

This article explains the concept of historical chain (slowly changing dimension) tables in data warehousing, demonstrates how to create source and target tables, provides a PL/pgSQL stored procedure to handle inserts, updates, and deletions, and shows step‑by‑step testing with sample SQL scripts.

PL/pgSQLSQLSlowly Changing Dimension

0 likes · 10 min read

Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL