4 posts in PostgreSQL
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 min read
PostgreSQL Cursor Tutorial in Java: How to Use JDBC CallableStatement for Large Data
Master PostgreSQL cursors in Java using JDBC and CallableStatement. Learn how to fetch large datasets efficiently with real-world examples and performance tips.
Nida Sahar5 min read
How to Debug PostgreSQL Stored Procedures: A Practical Guide
Learn how to troubleshoot and debug PostgreSQL stored procedures effectively. Understand common issues, debugging strategies, and best practices to optimize your database functions.
Nida Sahar5 min read
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 Sahar4 min read