GitHub

Oracle PL/SQL Package and APEX plugin for QR Code Generation

QR Codes Generator package provides functionality to quickly and efficiently generate QR Codes (module 2) directly from Oracle database. It requires no additional ...
fingerlakes1

Oracle Schema Compare – How to Do It With These 5 Easy Tools

Have you experienced breaking an app because you forgot to add or update new database objects? That’s one hell of a disruption to your users. Doing some Oracle schema compare could have avoided the ...
GitHub

Oracle PL/SQL Package for SVG Images Generation

SVG Images Generator PL/SQL package provides functionality to quickly and efficiently generate SVG images directly from the Oracle database. It requires no additional resources and it is developed in ...
IEEE

Performance Analysis of PL/SQL Query Optimization Techniques

Abstract: Optimization in PL/SQL Programming is the preeminent aspect for database related applications built using PL/SQL code. PL/SQL statement/Query can be written in different ways for fetching ...
IEEE

High performance PL/SQL programming

Abstract: Performance engineering is a vital aspect in PL/SQL programming, as most of the Database associated applications are built with PL/SQL Code. There subsists many ways of writing PL/SQL ...
dbta

Webcast Replay Available: Accelerating Performance and Reducing Costs with PL/SQL Optimization

Many IT developers have built complex and lengthy PL/SQL scripts to perform critical data processing tasks as a result of underperforming ETL tools, but as business requirements change and data ...
TechRepublic

Avoiding TOO_MANY_ROWS errors in PL/SQL

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...