|
Nearly a quartermillion PL/SQL programmersnovices and experienced developers alikehave found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds muchrequested 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 chapterdesigned especially for experienced PL/SQL developersdescribes 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:Recordbased 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 multiplelevel collections (nesting collections within.Collections), as well as associative arrays (previously called indexby 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.The book is divided into six parts:Part I, Programming in PL/SQL.Part II, PL/SQL Program StructurePart III, PL/SQL Program DataPart IV, SQL in PL/SQL.Part V, PL/SQL Application ConstructionPart VI, Advanced PL/SQL TopicsEven if you`ve been a PL/SQL developer for years, you`ll find an enormous amount of new and revised information in this third edition and on its companion web site. If you`re new to PL/SQL, you`ll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.
|
|
|