Expert Oracle PL/SQL

Design and Develop Advanced PL/SQL Solutions

Ron Hardman, Michael McLaughlin - Collection Oracle Press

492 pages, parution le 07/11/2005

Ajouter à une liste

Indisponible

Résumé

Create and debug next-generation, feature-rich PL/SQL applications

Push your PL/SQL programming skills to the next level with the extensive information contained in this volume. You'll learn how to write dynamic PL/SQL programs, interface with Oracle databases, execute complex calculations, and handle error conditions using advanced techniques. Plus, you'll get the latest on the PL/SQL Toolkit, Java integration, code threading, and performance optimizing. Oracle professionals Ron Hardman and Michael Mclaughlin cover all the bases, providing real-world examples, undocumented tricks, syntax samples, and unique solutions for every topic.

Compile high-performance PL/SQL scripts using procedures, functions, packages and triggers
Trap, trace, identify, and eliminate compile-time and runtime errors
Manage error propagation, stacks, regular expressions, and metacharacters
Extend PL/SQL functionality using server-side and internal Java class libraries
Build and run parallel PL/SQL program units using DBMS_JOB and DBMS_PIPE
Exploit definer's-rights and invoker's-rights architectures
Tune performance using statistics gathering, the PL/SQL optimizer, SQL Trace, DBMS_STATS, andTKPROF
Use OracleText with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching
Administer server-side PL/SQLToolkit web pages and PL/SQL Server Pages
Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMSJ3ATAPUMP, and DBMS_FILE_TRANSFER

L'auteur - Michael McLaughlin

Michael McLaughlin, Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming and Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. He worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.

Sommaire

Advanced Concepts, Internals, and Debugging Concepts
Invoker's Rights, Java Libraries, and Object Patterns
Optimizing PL/SQL Solutions
Text Management Using PL/SQL
PL/SQL Server Pages and Database Management
Appendixes
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw-Hill - Osborne
Auteur(s)	Ron Hardman, Michael McLaughlin
Collection	Oracle Press
Parution	07/11/2005
Nb. de pages	492
Format	18,5 x 23
Couverture	Broché
Poids	860g
Intérieur	Noir et Blanc
EAN13	9780072261943
ISBN13	978-0-07-226194-3