TruTek

Oracle PL/SQL has been around since the early 1990s, but it has been enhanced in many fundamental and important ways since then. Many PL/SQL developers still rely too heavily on the core PL/SQL functionality found in Oracle7 and Oracle8. If you feel that you are falling behind the PL/SQL learning curve and want to make sure that you are using the latest and greatest PL/SQL has to offer, you should attend " PL/SQL Programming for the 21st Century."

This seminar showcases the new and most important features of Oracle11g Database PL/SQL, from the function result cache to trigger enhancements. From there, it provides in-depth coverage of key new capabilities of PL/SQL from Oracle9i, including the vastly improved, self-optimizing compiler, table functions, multi-level and string-indexed collections, and dynamic SQL using both Native Dynamic SQL and DBMS_SQL. After attending this seminar, you will have a strong understanding of how to best take advantage of Oracle PL/SQL to solve the programming challenges you face in the 21^st Century.

Objectives

Attendees in this course will learn....

• About the most important new features that Oracle has added to the PL/SQL language in Oracle Database 11g
• How to apply collections (the PL/SQL equivalent of an array) to improve performance and simply algorithms
• Best practices for utilizing the best new features of Oracle9i, Oracle10g and Oracle 11g

Required Skills

Attendees should have at least six months working knowledge and experience with the PL/SQL language. You do not have to be an expert developer to benefit from this course.

Key Words

PL/SQL * Developer * SQL * Oracle 11g * Oracle10g * Performance

Target Audience

PL/SQL developers and Oracle DBAs

Topics

This training covers the most important new features of Oracle PL/SQL, with an emphasis on functionality added in Oracle 10g and Oracle 11g. The specific topics include:

• The new features of the Oracle PL/SQL compiler, including optimization, compile-time warnings, conditional compilation and inlining.
• High performance PL/SQL built around a variety of data caching mechanisms, most importantly the Oracle11g Function Result Cache.
• Use of collections with FORALL, and the new INDICES OF and VALUES OF clauses available in Oracle10g and the SAVE EXCEPTIONS close for powerful error management.
• The BULK COLLECT mechanism for rapid retrieval of multiple rows, with an emphasis on employing the LIMIT clause.
• Multi-level collections, including emulation of multi-dimensional arrays, nesting collections within objects and more.
• String-based indexing, which allows us to emulate a relational table's unique indexes for a collection, and also offers many new and interesting ways to store program data.
• The application of nested tables to table functions, and from there the interesting new capabilities inherent in PIPELINED functions.
• Oracle10g MULTISET operators for nested tables, allowing us to manipulate the contents of a nested table with set operations similar to those available in SQL.

• Dynamic SQL with Native Dynamic SQL and DBMS_SQL. All four methods of dynamic SQL are covered, including advice on when to use DBMS_SQL. New Oracle11g interoperability features will also be discussed.

• Reading and writing files with UTL_FILE: Oracle enhanced UTL_FILE in a number of crucial ways in Oracle9i Release 2. You can now work with database directories instead of UTL_FILE_DIR, remove files, copy and rename files, and get attribute information about files.
• Key error management functionality, from the wonderful DBMS_UTILITY.FORMAT_ERROR_BACKTRACE to the DBMS_ERRLOG package.

• Autonomous transactions: the ability to commit or rollback changes in a single PL/SQL block without affecting the outer or main transaction.
• Invoker rights: specifying that a store program runs under the authority of the current user or invoker, rather than the definer/owner of the program

As with any seminar taught by Steven Feuerstein, you will receive guidance on the best way to use all of these features, to ensure that your code is readable, easy to maintain and efficient.

Not finding the course or date that you're looking for? Let us know!