| CARVIEW |
By?Steven Feuerstein
With Bill?Pribyl
Third Edition
September 2002
Pages: 1018
ISBN 10: 0-596-00381-1 |
ISBN 13:9780596003814
(Average of 1 Customer Reviews)
This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.
The latest edition is also available on Safari Books Online.
Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have 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.
Authored by renowned PL/SQL experts Steven Feuerstein and Bill Pribyl, 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. Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions.
Full Description
- 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 within collections), 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
Cover | Table of Contents | Index | Sample Chapter | Colophon
Featured customer reviews
Oracle PL/SQL Programming, 3rd Edition Review, October 25 2002
I was a bit wary buying yet another Steve Feuerstein Bible, with my bookshelf already groaning under the weight of all the other ones including the 2nd Edition of this book. But he's never disappointed me yet, and this book was no exception. With all the latest 9i features blended right in, rather than being in their own section, it has made development easier when looking for the definitive reference to a complete code module. I particularly like Chapter 15 on NDS statements and dynamic PL/SQL and the entire Advanced PL/SQL section covering Java, External Procedures and PL/SQL Object Orientation. It is much better balanced than the 2nd Edition, more concise, and just better all round. A fine piece of work. I just get that Oracle 9i PL/SQL job just done quicker. Anybody want to buy an old 2nd Edition? No good to me anymore.
Media reviews
"With the significant enhancements of Oracle9i, PL/SQL continues to be a critical element of successful Oracle-based applications. Over the years, the brilliantly written book, Oracle PL/SQL Programming, has become the "PL/SQL bible" for developers around the world. This third edition is the best of them all. Steven Feuerstein and Bill Pribyl cover PL/SQL completely, including all the new Oracle9i features of PL/SQL, and provide even more real-world examples. This is a book that belongs in the library of every serious Oracle application developer."
--Ken Jacobs, Vice-President, Product Strategy, Server Technologies, Oracle Corporation
"I have a long history with Oracle PL/SQL Programming. I used the first edition to teach myself PL/SQL. I now lead the Data Warehouse Group at Children's Hospital Boston, and we use PL/SQL heavily in our development. The second edition has for years been our authoritative reference. I am glad to find that the third edition continues to communicate complex technical issues in an understandable, informative fashion. I have no doubt that Oracle PL/SQL Programming will figure prominently as a key resource in our development efforts for years to come."
--Jeanne Greeno, Data Warehouse Group, Children's Hospital Boston
"I would recommend it to anyone who needs a thorough introduction to PL/SQL, as well as a good reference book."
--Williamsburg Macromedia User Group, February 12, 2003
About O'Reilly | Contact | Jobs | Press Room | How to Advertise | Privacy Policy
|
© 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.