GitHub

oracle-plsql

Advanced SQL, covering Oracle PL/SQL and PostgreSQL PL/pgSQL with phases on using procedures, functions, triggers, query optimizations, packages, and Docker server setup 💡 ...
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

Improving optimization performance on PL/SQL

Abstract: This research aims to present techniques for improving database performance by optimizing PL/SQL using 24 different approaches, including techniques such as Using Index, Out Number Technique ...
Scientific Research Publishing

Using Genetic Algorithm as Test Data Generator for

PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and ...
Scientific Research Publishing

Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units ()

PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored program units (Procedures, Functions, and Packages) to improve software reusability and ...