Oracle and PLSQL Recipes A Problem-Solution Approach

Contents at a Glance
 About the Authors............................................................................................ xxxiv
 About the Technical Reviewer .......................................................................... xxxv
 Acknowledgments ........................................................................................... xxxvi
 Introduction ................................................................................................... xxxviii
 Chapter 1: PL/SQL Fundamentals ...........................................................................1
 Chapter 2: Essential SQL.......................................................................................15
 Chapter 3: Looping and Logic ...............................................................................43
 Chapter 4: Functions, Packages, and Procedures ...............................................63
 Chapter 5: Triggers...............................................................................................93
 Chapter 6: Type Conversion................................................................................119
 Chapter 7: Numbers, Strings, and Dates ............................................................133
 Chapter 8: Dynamic SQL .....................................................................................155
 Chapter 9: Exceptions.........................................................................................187
 Chapter 10: PL/SQL Collections and Records .....................................................215
 Chapter 11: Automating Routine Tasks ..............................................................233
 Chapter 12: Oracle SQL Developer ......................................................................247
 Chapter 13: Analyzing and Improving Performance...........................................281
 Chapter 14: Using PL/SQL on the Web ................................................................291
 Chapter 15: Java in the Database.......................................................................319
 Chapter 16: Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython...............345
 Chapter 17: Unit Testing With utPLSQL...............................................................361
 Index ...................................................................................................................391


Another Database Books
Download