Oracle and PL/SQL Recipes: A Problem-Solution Approach

  • 6h 49m
  • Josh Juneau, Matt Arena
  • Apress
  • 2010

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you’re done and home for dinner.

Oracle PL/SQL Recipes is another in Apress’ ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done.

  • Covers the most common PL/SQL programming problems
  • Presents solutions in ready-to-use format
  • Stays short and to-the-point

What you’ll learn

  • Move business logic into the database
  • Implement robust exception-handling
  • Optimize and debug, taking advantage of Oracle SQL Developer
  • Integrate PL/SQL with web-based applications
  • Interface with Java code and dynamic languages in the database, and running externally
  • Run the UTPLSQL unit-testing framework

About the Authors

Josh Juneau has been developing software since the mid-1990s. Database application programming has been the focus of his career since the beginning. He became an Oracle Database administrator and adopted the PL/SQL language for performing administrative tasks and developing applications for Oracle Database. As his skills evolved, he began to incorporate Java into his PL/SQL applications and later began to develop stand-alone applications in Java. During his tenure as a developer, he has combined his knowledge of PL/SQL and Java to develop robust Oracle Database applications that harness the great features offered by both technologies. He has extended his knowledge of the JVM by learning and developing applications with other JVM languages such as Jython and Groovy. His interest in learning new languages that run on the JVM led to his interest in Jython. Since 2006, Josh has been the editor and publisher for the Jython Monthly newsletter. In late 2008, he began a podcast dedicated to the Jython programming language. Josh was the lead author for The Definitive Guide to Jython, which was published in early 2010 by Apress. He has most recently become the lead for the Django-Jython project (, after developing the project's implementation for the Oracle Database. To hear more from Josh, follow his blog at You can also follow him on Twitter via @javajuneau.

Matt Arena has been developing Oracle Database applications for 25 years. He's focused on web-based applications since the Web was first developed. Matt has worked in every phase of the project development life cycle but enjoys database modeling and programming the most.

In this Book

  • PL/SQL Fundamentals
  • Essential SQL
  • Looping and Logic
  • Functions, Packages, and Procedures
  • Triggers
  • Type Conversion
  • Numbers, Strings, and Dates
  • Dynamic SQL
  • Exceptions
  • PL/SQL Collections and Records
  • Automating Routine Tasks
  • Oracle SQL Developer
  • Analyzing and Improving Performance
  • Using PL/SQL on the Web
  • Java in the Database
  • Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython
  • Unit Testing With utPLSQL