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

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

by Josh Juneau, Matt Arena

NOOK Book(eBook)

$41.99 $47.99 Save 13% Current price is $41.99, Original price is $47.99. You Save 13%.

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now

Product Details

ISBN-13: 9781430232087
Publisher: Apress
Publication date: 12/08/2010
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 456
File size: 2 MB

About the Author

Josh Juneau has been developing software since the mid-1990s. PL/SQL development and database programming was the focus of his career in the beginning, but as his skills developed, he began to use Java and later shifted to it as a primary base for his application development. Josh has worked with Java in the form of graphical user interface, web, and command-line programming for several years. During his tenure as a Java developer, he has worked with many frameworks such as JSF, EJB, and JBoss Seam. At the same time, Josh has extended his knowledge of the Java Virtual Machine (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.
Matt Arena has been developing Oracle database applications for 25 years. He's focused on web-based applications since the world wide Web was first developed. Matt has worked in every phase of the project development life cycle, but enjoys database modeling and programming the most.

Table of Contents

  1. PL/SQL Fundamentals
  2. Essential SQL
  3. Looping and Logic
  4. Functions, Packages, and Procedures
  5. Triggers
  6. Type Conversion
  7. Numbers, Strings, and Dates
  8. Dynamic SQL
  9. Exceptions
  10. PL/SQL Collections and Records
  11. Automating Routine Tasks
  12. Oracle SQL Developer
  13. Analyzing and Improving Performance
  14. Using PL/SQL on the Web
  15. Java in the Database
  16. Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython
  17. Unit Testing With utPLSQL

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews