Download Now! (1.2 MB, Updated: 11/5/04)
 

It is well past time for programmers to recognize that the role we play in our society goes far beyond our cubicles. What we do - the code we write, the bugs we don't manage to fix - has an enormous impact on the world, on the daily lives of millions of people. In other words, we - programmers and DBAs both - are very powerful. And as Spidey's uncle said, "With great power comes great responsibility."
 

This keynote presentation (delivered at the Kansas City OUG Fall Conference, October 26, 2004) explains just how and why our jobs and our work product are vastly more important than you might have been thinking. We will then explore the ways in which attendees can accept their responsibility and becomes the heroines and heroes of the 21st century.

Download Now! (131 KB, Updated: June 24, 2006)
 

Detailed Description
 

No doubt about it: PL/SQL is the best place to write SQL when you need to access the Oracle database.  No need for JDBC, ODBC or any of that other nonsense!  Just write your SQL and off you go...but wait, it gets even better!  Over the past several versions, Oracle has added SQL-centric functionality to PL/SQL to make it easier to write and faster to run SQL from within PL/SQL programs.
 

This one-hour presentation will make sure you know about all the things you can do to take maximum advantage of SQL inside PL/SQL, from BULK COLLECT and FORALL to table functions, with a visit into the world of record-level DML.
 

Prerequisites
 

You should have a working knowledge of PL/SQL and at least a year's worth of experience with the language.  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 versions of Oracle, but will also showcase new features in Oracle Database 10g that can dramatically improve the quality and performance of code that you write.
 

The Download
 

This download contains the following file:

• Hands-on collections.ppt - A Powerpoint presentation

Download Now! (236KB, Updated September 2005)
 

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

And don't forget to download the demonstration files!

Download Now! (214KB)
 

Winner of ODTUG Now 2005's Editor's Choice Award!