Best of Oracle PL/SQL with László Czinkóczki, 23 February 2010 February 22, 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/NPEhBD