Best of Oracle PL/SQL with László Czinkóczki, Tallinn June 20, 2010

In this seminar the participants will learn best practices for developing PL/SQL programs and will become familiar with enhanced exception handling, efficient cursor design and new features of Bulk Binding. The seminar covers how to use efficiently the overloaded subprograms.

The delegates learn when and how to use the Native Dynamic SQL and PL/SQL. During the seminar the delegates will execute many programs, which demonstrate the best coding technologies. The memory management is also a focus.

After completing this course, you should be able to do the following:

Design PL/SQL packages Standardize the Exceptions
Cursors Using new technologies for Bulk Binding
Influence the behavior of the PL/SQL engine
Using collections and Table Functions
Chose when and how to use Native
Dynamic SQL and PL/SQL
Using the buffer technology (Bulk Binding)
Exploring the metadata of Oracle objects. Analyze and profiling the PL/SQL code
Using Compound triggers in Oracle 11g

Official Website: http://cli.gs/81SGs8