note

Pitfalls in Migrating Oracle PL/SQL to PostgreSQL: Explaining How to Rewrite Transactions and Packages

In database migration projects from Oracle to PostgreSQL, converting from the stored procedure language PL/SQL to PL/pgSQL is one of the most complex and difficult tasks. Many migration projects ...
Hacker

How to Create Purchase Order Lines in Oracle R12 (with PL/SQL Examples)

Vinish Kapoor is an Oracle ACE Pro, software developer, and founder of Vinish.dev, known for his expertise in Oracle. Vinish Kapoor is an Oracle ACE Pro, software developer, and founder of Vinish.dev, ...
LinkedIn

Autonomous Transactions in PL/SQL

Autonomous Transactions in PL/SQL allow subprograms to execute SQL operations independently of the main transaction, enabling partial commits without affecting the parent transaction. They are ...
LinkedIn

Mastering Dynamic SQL, DDL, TCL, and External Procedures in PL/SQL

PL/SQL (Procedural Language/SQL) is a powerful extension of SQL that allows developers to write procedural code for database applications. This article dives deep into Dynamic SQL, DDL (Data ...
GitHub

pl-sql

Console applications for connection to the Oracle database, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection ...