Oracle and PL/SQL 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