This new training session, created specially for Quest Software Europe, will bring you up to date on all the new PL/SQL features available in Oracle Database 10g releases 1 and 2, from fundamental enhancements of the PL/SQL compiler to fantastic new collection capabilities.

Simply learning about new features however, doesn't necessarily give you much guidance in how to apply the functionality. Popular PL/SQL trainer and author, Steven Feuerstein, will therefore take you on an entertaining journey through a startling geography of truly awful or out-of-date PL/SQL code and provide directions for reaching the new world of PL/SQL where your code runs much faster, is easier to maintain, and no longer reflects the old-fashioned way of writing code.

This training seminar will cover Correcting PL/SQL Worst Practices and Survey of Oracle Database 10g PL/SQL New Features. Topic covered in this section will include:

1. Correcting PL/SQL Worst Practices
The bad old days of cursor FOR loops
Hard-coding? Let me count the ways…
Optimistic programming or just plain laziness?

2. Survey of Oracle Database 10g PL/SQL New Features
The amazing new PL/SQL compiler
Collections get better and better
Leverage new and enhanced built-in packages

[top]