SQL debugging tools

2 posts in SQL debugging tools

Oracle vs PostgreSQL Stored Procedures: Syntax, Debugging & Examples Compared

Compare Oracle and PostgreSQL stored procedures with syntax examples, debugging strategies, and practical tips for cross-database SQL development.

Nida Sahar4/8/20254 min read

PostgreSQL

From ORA to PG: A Casual Guide to Converting Stored Procedures

Changing to PostgreSQL (PG) from Oracle (ORA)? One of those things that can be annoying, but rewarding when done correctly, is converting stored processes. It's similar to untangling your earbuds. Don't worry if you're new to translating from PL/SQL to PL/pgSQL; I've got you covered. We'll discuss how to do it, what to look out for, and how to maintain your sanity.

Nida Sahar12/3/20244 min read