Oracle PL/SQL Programming
Steven Feuerstein, Bill Pribyl
Résumé
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. 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
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.
Contents
Part I. Programming in PL/SQL
- 1. Introduction to PL/SQL
- 2. Creating and Running PL/SQL Code
- 3. Language Fundamentals
Part II. PL/SQL Program Structure
- 4. Conditional and Sequential Control
- 5. Iterative Processing with Loops
- 6. Exception Handlers
Part III. PL/SQL Program Data
- 7. Working with Program Data
- 8. Strings
- 9. Numbers
- 10. Dates and Timestamps
- 11. Records and Collections
- 12. Miscellaneous Datatypes
Part IV. SQL in PL/SQL
- 13. DML and Transaction Management
- 14. Data Retrieval
- 15. Dynamic SQL and Dynamic PL/SQL
Part V. PL/SQL Application Construction
- 16. Procedures, Functions, and Parameters
- 17. Packages
- 18. Triggers
- 19. Managing PL/SQL Applications
Part VI. Advanced PL/SQL Topics
- 20. PL/SQL's Runtime Architecture
- 21. Object-Oriented Aspects of PL/SQL
- 22. Calling Java from PL/SQL
- 23. External Procedures
L'auteur - Steven Feuerstein
Steven Feuerstein is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL for DBAs, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, and several pocket reference books (all from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and serves as a Senior Technology Advisor to Quest Software. His products include utPLSQL (an open source unit testing framework for PL/SQL) and Qnxo (active mentoring software that helps to generate, reuse, and test code. He has won numerous awards for his writing and trainings, offers a PL/SQL portal, and can be reached via email at steven@stevenfeuerstein.com. He lives in Chicago with his wife, Veva, and three cats. Two sons, Eli and Chris, orbit nearby.
L'auteur - Bill Pribyl
Bill Pribyl, author, teacher, and software consultant,
is coauthor of the best-selling Oracle PL/SQL Programming
and its companion pocket reference, both published by
O'Reilly & Associates. An Oracle user for 15 years,
Bill has consulted on many aspects of using Oracle
products. He recently spearheaded PLNet.org, a web-based
repository where, developers can share open source PL/SQL.
At home in Houston, Bill volunteers with a Christian
organization teaching computer skills to low-income
clients, and he says his next project will be persuading
fellow database technologists, to contemplate the ethical
and moral implications of all their work. Visit Bill at
http://www.datacraft.com.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | O'Reilly |
Auteur(s) | Steven Feuerstein, Bill Pribyl |
Parution | 05/11/2002 |
Édition | 3eme édition |
Nb. de pages | 990 |
Format | 18 x 23 |
Couverture | Broché |
Poids | 1320g |
Intérieur | Noir et Blanc |
EAN13 | 9780596003814 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse