Oracle PL/SQL Expertise On-line: PL/SQL Webinars

I will be presenting another three-part series of webinars for Oracle Europe. Click here to register; here's information about the three topics:

• 20 July 2010 2PM - 4:30PM CET - Programming with Collections:

  Collections (array-like structures in PL/SQL) are critical data
  structures that are used in some of the most important features of
  PL/SQL. Every PL/SQL developer should have a deep familiarity with
  collections and the wide range of features that Oracle has implemented
  for them over the years.

  This session introduces collections and quickly moves on to detailed
  explanations of collection methods, how to leverage string indexing in
  associative arrays, multi-level collections, set-level operations on
  nested tables and more.

  After attending this webinar, you will be well-positioned to apply
  collections in your every day development and, most important, take
  advantage of features like BULK COLLECT and FORALL to improve
  application performance.

• 21 July 2010 2PM - 4:30PM CET - Say Goodbye to Hard-Coding in PL/SQL:

  Everyone knows that hard-coding is a bad idea. Too many developers,
  however, only think in terms of literal values when they think of
  hard-coding. There are, unfortunately, many ways that hard-coding
  manifests itself in our programs.

  This webinar offers a comprehensive look at all the types of
  hard-coding that can appear in your programs, from literals to explicit
  declarations to exposed formulas, and offers specific techniques to get
  rid of the hard-coding. The result is code that is much easier to read
  and to maintain.

  After attending this webinar, you will be able to more easily and
  quickly identify hard-codings, and apply well-understood and safe
  transformations to remove those hard-codings.

• 22 July 2010 2PM - 4:30PM CET - Dynamic SQL in Oracle PL/SQL:

  Dynamic SQL (construction, parsing and execution of SQL statements and
  PL/SQL blocks at runtime) has become a common and critical element of
  most modern applications. PL/SQL offers two distinct methods for
  dynamic SQL: native dynamic SQL (NDS) and DBMS_SQL.

  This webinar focuses primarily on the capabilities of native dynamic
  SQL: how to use EXECUTE IMMEDIATE to execute dynamic query, DML, and
  DDL statements. We will also go beyond the basics and delve into when
  to use DBMS_SQL (method 4 dynamic SQL), and new Oracle Database 11g features for dynamic SQL (most importantly, interoperability between DBMS_SQL and NDS.

  After attending this webinar you will be able to quickly identify the
  type of dynamic SQL challenge you face and from there apply the correct
  PL/SQL functionality to get the job done.