Oracle LVC (Live Virtual Classroom) Webinar Series

A three part webinar series of 2.5 hours sessions each, Feb 23-25 2009, sponsored by Oracle. Click here to register.

• 23 February 2010 2PM 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.

• 24 February 2010 2PM 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.

• 25 February 2010 2PM 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.