Skip navigation.

harrysmall3's blog

ORACLE OOP SQL APPROACH TO COMPLEX DATA TRANSFORMATION: OVERCOME PL/SQL STRIING FUNCTION INEFFICIENCIES

This Blog is to be serve as a compilation of my research in preparation for a paper on
The extreme performance issues with PL/SQL String Functions and how to circumvent their usage using Straight SQL. The Object Oriented approach allows SQL to be virtually executed against "Anything" not just tables - data fields, variables, even a single character!