Expand your PL/SQL knowledge to the next level by using hundreds of PL/SQL tips and techniques provided in this one-of-a-kind reference that's designed for every Oracle developer and database administrator. This book highlights many solutions that are either hidden or undocumented or can only be discovered through many years of experience or through laborious trial and error. In "Oracle PL/SQL Tips & Techniques," you will find hundreds of real-world examples, scripts and insider secrets compiled from TUSC's standing-room-only conference presentations and Oracle users groups worldwide. This invaluable PL/SQL arsenal can be deployed in your environment to catapult your current Oracle and PL/SQL knowledge to the next level. Reviews "I picked up this book a few weeks ago and so far so good. It has a great deal of USEFUL practical examples. Time will tell if it is really the best reference out there, but I have learned a great deal from it already." -- Amazon Reader Review "The summary accurately reflects this book's contents. This reference for database administrators (DBAs) and application developers covers Oracle8 and 8i. Based on real-world problems and solutions, this publication is filled with practical tips and techniques that are structured in a what, why and how format. The authors define problems, explain why they are important and provide useful code examples that illustrate and solve specific problems." -- Fatbrain.com Review About the Author Joseph C. Trezzo is president and chief operating officer of TUSC. He has worked with Oracle technology for more than a decade and is a certified Oracle database administrator. Throughout his career, he has served as a developer, DBA and project leader. Joe is often requested to submit white papers and appear on expert panels for both Oracle and professional users groups. The International Oracle Users Group-Americas named him top speaker in the world in 2001 and 1998. Click here to learn more about Joe. Table of Contents		Author Joseph C. Trezzo Book Information Paperback 942 pages ISBN: 0072224738 Downloads Sample Scripts (271Kb) Order it from Amazon
Chapter 1: Reviewing PL/SQL Growth and Setting the Stage (Developer and DBA) Chapter 2: Maximizing PL/SQL Development with the Power of SQL (Developer and DBA) Chapter 3: Establishing PL/SQL Coding Standards (Developer and DBA) Chapter 4: Defining Standard PL/SQL Coding Techniques (Developer and DBA) Chapter 5: Defining Standard PL/SQL Program Unit Techniques (Developer and DBA) Chapter 6: Exploring the Expansive PL/SQL Language Commands Chapter 7: Maximizing PL/SQL by Optimizing SQL (Developer and DBA) Chapter 8: Maximizing PL/SQL by Optimizing PL/SQL (Developer and DBA) Chapter 9: Examining DBA-Related PL/SQL Issues (DBA) Chapter 10: Unlocking PL/SQL Security (Developer and DBA) Chapter 11: Exploring the Oracle Supplied PL/SQL Packages (Developer and DBA) Chapter 12: Understanding the Power of the Oracle Supplied PL/SQL Packages (Developer and DBA) Chapter 13: Taking Advantage of the PL/SQL Data Dictionary (Developer and DBA) Chapter 14: Exploring PL/SQL Product Integration (Developer and DBA) Chapter 15: Understanding the Critical Role of PL/SQL in the Web (Developer and DBA) Chapter 16: New PL/SQL-Related Features in Oracle8 and Oracle8i (Developer and DBA) Appendix A: The Example Database (Developer and DBA) Appendix B: PL/SQL Quick Reference (Developer and DBA) Appendix C: PL/SQL Data Dictionary Reference (Developer and DBA)