This page gives a single view on the Scribd articles I’ve published, which I’ve grouped as follows:

Templates and Standards

• A Database System High Level Design Template
• Unit Test Plan Template
• Oracle Forms Generic UTP
• Oracle Applications Extension Installation Template (actually is more general than just Oracle Applications)
• IT Project Development To Release Processes

SQL and PL/SQL

• A Structured Approach to SQL Query Design
• Forming Range-Based Break Groups With Advanced SQL
• SQL Pivot and Prune Queries – Keeping an Eye on Performance
• Code Timing and Object Orientation and Zombies
• An Oracle Network Traversal PL SQL Program

Oracle Applications

• Oracle Applications FNDLOAD Unix Scripts
• Oracle Multi-Org – AR and OM Data Structure Changes
• Oracle Applications Utility SQL Scripts (actually is more general than just Oracle Applications)
• Batch Migration and Loading of Oracle FND Data

Perl

• A Perl Object for Flattened Master-Detail Data in Excel

Unix-Perl-SQL-Excel

• Analysing Unix System Performance With prstat and SQL

Here are the documents, embedded:

Templates
A Database System High Level Design Template

Unit Test Plan Template

Oracle Forms Generic UTP

Oracle Applications Extension Installation Template

IT Project Development To Release Processes

SQL and PL/SQL
A Structured Approach to SQL Query Design

Forming Range-Based Break Groups With Advanced SQL

SQL Pivot and Prune Queries – Keeping an Eye on Performance

Code Timing and Object Orientation and Zombies

An Oracle Network Traversal PL SQL Program

Oracle Applications
Oracle Applications FNDLOAD Unix Scripts

Oracle Multi-Org – AR and OM Data Structure Changes

Oracle Applications Utility SQL Scripts

Batch Migration and Loading of Oracle FND Data

Perl
A Perl Object for Flattened Master-Detail Data in Excel

Unix-Perl-SQL-Excel
Analysing Unix System Performance With prstat and SQL