Oracle Plsql By Example 3rd Edition Benjamin Rosenzweig Elena Silvestrova by Benjamin Rosenzweig, Elena Silvestrova 9780131172616, 0131172611 instant download after payment.

This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter--designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL.The book contains information about the latest Oracle9i PL/SQL features, including:

• Record-based DML: You can now use records in INSERT and DELETE statements.
• Table functions: These are functions that return a result set (in the form of a PL/SQL collection). Such functions existed in Oracle8i but they are now much expanded.
• New and improved datatypes: Oracle now offers dramatically improved support for timestamps, time zone management, and interval calculations. In addition, the XMLType datatype has now been implemented.
• Inheritance for object types: You can now define a hierarchy of object types (which were first introduced in Oracle8).
• Enhancements to PL/SQL collections. PL/SQL now supports multiple-level collections (nesting collections withincollections), as well as associative arrays (previously called index-by tables), which allow you to index by PLS_INTEGER and VARCHAR2.
• Native compilation of PL/SQL code: PL/SQL source code can now optionally be compiled into native object code that is linked into Oracle.

• Part I, Programming in PL/SQL
• Part II, PL/SQL Program Structure
• Part III, PL/SQL Program Data
• Part IV, SQL in PL/SQL
• Part V, PL/SQL Application Construction
• Part VI, Advanced PL/SQL Topics