Oracle PL/SQL Tips and Techniques

Bradley D. Brown, Joseph C. Trezzo, and Richard J. Niemiec are co-founders of TUSC (The Ultimate Software Consultants), an award-winning, senior-level RDBMS consulting company specializing in Oracle. Trezzo has served as Ediotr-In-Chief and Brown Executive Editor of the Exploring Oracle DBMS magazine. Niemiec is the Executive Vice-President of ILUG-A's Select magazine. These three are the driving force behind TUSC's success--their efforts were most recently recognized by their induction into the Entrepreneur Hall of Fame.

Reviewing PL/SQL Growth and Setting the Stage (Developer and DBA). Maximizing PL/SQL Development with the Power of SQL (Developer and DBA). Establishing PL/SQL Coding Standards (Developer and DBA). Defining Standard PL/SQL Coding Techniques (Developer and DBA). Defining Standard PL/SQL Program Unit Techniques (Developer and DBA). Exploring the Expansive PL/SQL Language Commands. Maximizing PL/SQL by Optimizing SQL (Developer and DBA). Maximizing PL/SQL by Optimizing PL/SQL (Developer and DBA). Examining DBA-Related PL/SQL Issues (DBA). Unlocking Pl/SQL Security (Developer and DBA). Exploring the Oracle Supplied PL/SQL Packages (Developer and DBA). Understanding the Power of the Oracle Supplied PL/SQL Packages (Developer and DBA). Taking Advantage of the PL/SQL Data Dictionary (Developer and DBA). Exploring PL/SQL Product Integration (Developer and DBA). Understanding the Critical Role of PL/SQL in the Web (Developer and DBA). New Pl/SQL Related Features in Oracle 8 and Oracle 8i (Developer and DBA). Appendices: A: The Example Database (Developer and DBA). B: PL/SQL Quick Reference (Developer and DBA). C: PL/SQL Data Dictionary Reference (Developer and DBA).