GitHub

PL/SQL Connector Builder Examples

These examples demonstrates all data types and PL/SQL Connector Builders used by PL/SQL Enterprise Workbench. All examples contain a normal executable main Java program and a JUnit test case. These ...
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, ...
dbta

Working with JSON in Oracle APEX: Best Practices and Performance Optimization

JSON (JavaScript Object Notation) has become the de facto standard for lightweight data exchange across applications, especially within modern web-based platforms. For Oracle APEX developers, JSON ...
GitHub

Shortest Path Analysis of Large Networks by SQL and PL/SQL

This project is on the use of SQL and PL/SQL to solve shortest path problems on large networks on an Oracle database. It provides solutions in pure SQL (based on previous articles by the author), and ...
IEEE

Reverse Engineering PL/SQL Legacy Code: An Experience Report

Abstract: The reengineering of legacy code is a tedious endeavor. Automatic transformation of legacy code from an old technology to a new one preserves potential problems in legacy code with respect ...