Oracle PL/SQL Language
Pocket Reference
Steven Feuerstein, Bill Pribyl, Chip Dawes
Résumé
The second edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle9i Release 2 features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PI/SQL Programming.
This concise guide boils down the most vital information from the larger book into an accessible quick-reference to fundamental language elements (e.g., block structure, identifiers, variables, datatypes, and declarations); statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/SQL functions in SQL. It also includes Oracle's object-oriented features, collections, external procedures, Java integration, and such Oracle9i elements as new timestamp and interval datatypes, CASE statements and expressions, native compilation of PL/SQL, pipelined table functions, object type inheritance, upcasting/ downcasting of subtypes, nested collections, and much more.
Contents
- PL/SQL Language Fundamentals
- Variables and Program Data
- Conditional and Sequential Control
- Loops
- Database Interaction
- Cursors in PL/SQL
- Exception Handing
- Records in PL/SQL
- Named Program Units
- Triggers
- Packages
- Calling PL/SQL Functions in SQL
- Oracle's Object-Oriented Features
- Collections
- External Procedures
- Java Language Integration
- Reserved Words
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.
L'auteur - Chip Dawes
Chip Dawes, OCP, is a consultant with D&D Technologies and presents at various Oracle User Group conferences.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Steven Feuerstein, Bill Pribyl, Chip Dawes |
| Parution | 14/03/2003 |
| Édition | 2eme édition |
| Nb. de pages | 128 |
| Format | 11 x 17,7 |
| Couverture | Broché |
| Poids | 119g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596004729 |
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
