OOUG would like to announce Steven Feuerstein is coming to Columbus for a one day training seminar.

We will finish with a quiz on the topics covered, and prizes awarded to the top 5 scorers. Winners will be announced at the PL/SQL Challenge website, where thousands of Oracle technologists play daily, weekly and monthly quizzes on PL/SQL, SQL and APEX.

Steven Feuerstein Registration

OOUG Non-Member $386.25 USD OOUG Member $334.75 USD

Overview

In 2012, the Oracle PL/SQL language will celebrate its 23rd birthday. Not bad for a language that initially found its application inside SQL*Forms V3 and is now widely regarded as the most powerful, flexible and well-structured relational database programming language.

Twenty-three years also has provided Oracle with lots of opportunity to enhance PL/SQL, which makes it ever more challenging for programmers to keep up with all the enhancements.

This one-day training covers the most critical features you need to know about if you are going to write PL/SQL programs that fully utilize the capabilities of PL/SQL, including the most important enhancements of Oracle Database 11g.

About Steven

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). In 2010, Steven started the PL/SQL Challenge ( www.PLSQLChallenge.com), an online, daily PL/SQL quiz. In 2011, he launched PL/SQL Channel (www.plsqlchannel.com), a library of over 27 hours of detailed training on Oracle PL/SQL. Steven's online PL/SQL cyberhome is located at www.ToadWorld.com/SF; but you can also find out more about Steven at www.StevenFeuerstein.com

Topics to be Covered

• Bulk Processing with BULK COLLECT and FORALL: the most important performance optimization feature of PL/SQL, bulk processing turbo-charges the speed of repeated execution of the same SQL statement (think: DML inside a loop) by reducing the number of context switches. We'll explore every nook and cranny of BULK COLLECT and FORALL.
• The Function Result Cache (11g): a fantastically elegant and high-impact feature, the function result cache provides an SGA-based cache that helps you optimize the performance of queries across an entire instance that repeatedly retrieve the same rows of data.
• Row-Level Error Suppression in DML: added in Oracle Database 10g Release 2, the LOG ERRORS clause (along with the built-in package, DBMS_ERRLOG) offers row-level suppression of errors in DML statements, especially helpful when modifying large numbers of rows.
• PL/Scope (11g): new to Oracle Database 11g, PL/Scope analyzes the way that all identifiers (variables, constants, subprograms, exceptions, types, etc.) are used in your code. It allows us to perform analysis on our code in a way never before possible. For example, you can implement your own scripts to check code for compliance with naming conventions - no parser required!
• The NOCOPY Hint: so simple, and yet so impactful. Add one keyword to your IN OUT parameter definition and get a significant boost in performance. Along the way, learn about the difference between formal parameters and actual argument values, passing by reference vs. value.
• Dynamic SQL Advanced Features: Oracle Database 11g includes many enhancements for dynamic SQL, especially for Method 4 dynamic SQL.
• Advanced Collection Features: the year is 2012 and all PL/SQL developers should be aware of and use collections (PL/SQL's version of arrays). So we'll skip the basics and concentrate on advanced features like use of the TABLE operator, string-indexed associative arrays, and nested collections.

Target Audience

Developers or DBAs with a working knowledge of PL/SQL and at least a year's worth of experience with the language. However, all developers, from beginner to expert, will benefit from Steven's ideas and examples.

Oracle Version

Steven will demonstrate techniques and principles that apply to all recent versions of Oracle, but will also showcase new features in Oracle Databases 10g and 11g that can dramatically improve the quality and performance of code that you write.

Meeting Dates for 2012