Oracle PL/SQL Programming
Steven Feuerstein, Bill Pribyl
Résumé
For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
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.
Sommaire
- Programming in PL/SQL
- Introduction to PL/SQL
- Creating and running PL/SQL code
- Language fundamentals
- PL/SQL program structure
- Conditional and sequential control
- Iterative processing with loops
- Exception handlers
- PL/SQL program data
- Working with program data
- Strings
- Numbers
- Dates and timestamps
- Records
- Collections
- Miscellaneous datatypes
- SQL in PL/SQL
- DML and transaction management
- Data retrieval
- Dynamic SQL and dynamic PL/SQL
- PL/SQL application construction
- Procedures, functions, and parameters
- Packages
- Triggers
- Managing PL/SQL code
- I/O and PL/SQL
- Advanced PL/SQL topics
- Application security and PL/SQL
- Inside PL/SQL
- Globalization and localization in PL/SQL
- Object-oriented aspects of PL/SQL
- Calling Java from PL/SQL
- External procedures
- A Regular expression metacharacters and function parameters
- B Number format models
- C Data format models
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Steven Feuerstein, Bill Pribyl |
| Parution | 03/03/2006 |
| Édition | 4eme édition |
| Nb. de pages | 1198 |
| Format | 17,5 x 23,5 |
| Couverture | Broché |
| Poids | 1480g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596009779 |
| ISBN13 | 978-0-596-00977-9 |
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
