
Expert Oracle PL/SQL
Osborne/McGraw-Hill (Publisher)
Published on 16. October 2005
Book
Paperback/Softback
496 pages
978-0-07-226194-3 (ISBN)
Description
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
Exploit definer's-rights and invoker's-rights architectures
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, and TKPROF
Use Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching
Administer server-side PL/SQL Toolkit web pages and PL/SQL Server Pages
Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER
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
Exploit definer's-rights and invoker's-rights architectures
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, and TKPROF
Use Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching
Administer server-side PL/SQL Toolkit web pages and PL/SQL Server Pages
Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER
More details
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
60 Illustrations
Dimensions
Height: 234 mm
Width: 187 mm
Thickness: 32 mm
Weight
852 gr
ISBN-13
978-0-07-226194-3 (9780072261943)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.
Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.
Content
Part I: PL/SQL Advanced Concepts, Internals, and DebuggingChapter 1: Introduction to Advanced Concepts, Patterns, and TechniquesChapter 2: PL/SQL InternalsChapter 3: Debugging PL/SQL ApplicationsPart II: Invoker Rights, Java Libraries, and Object PatternsChapter 4: Invoker's-Rights ArchitectureChapter 5: Extending PL/SQL with Java LibrariesChapter 6: Implementing PL/SQL ObjectsPart III: Optimizing PL/SQL SolutionsChapter 7: Threading PL/SQL ExecutionChapter 8: High Performance PL/SQLPart IV: Text Management Using PL/SQLChapter 9: Introduction to Information RetrievalChapter 10: Introduction to Regular ExpressionsPart V: PL/SQL Server Pages and Database ManagementChapter 11: Leveraging the PL/SQL ToolkitChapter 12: Managing the DatabaseAppendix A: REGULAR EXPRESSION METACHARACTERS AND FUNCTIONSAppendix B: ORACLE TEXT SUPPLIED PACKAGESAppendix C: PL/SQL TOOLKIT PACKAGESAppendix D: BASIC PRIMER ON JAVA AND JAVA DATABASE CONNECTIVITY (JDBC)INDEX