Oracle PL/SQL Expert Guide: Advanced PL/SQL Solutions Design and Development

Author: Ron Hardman
Publisher:
Publish Date: 2006-12-01
Features: This book contains a wealth of information that can elevate your programming skills to a new level. You will learn to write dynamic PL/SQL programs and Oracle database interfaces, perform complex calculations, and use advanced techniques to control error conditions. Additionally, you will gain new insights into PL/SQL Toolkit, Java integration, and performance optimization. Oracle professionals Ron Hardman and Michael McLaughlin have included all the necessary data in this book, providing real-world examples, numerous tips, syntax examples, and unique solutions for each topic. The main contents of this book include:
● Compile high-performance PL/SQL scripts using procedures, functions, packages, and triggers
● Capture, track, identify, and eliminate compilation errors 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
● Develop developer rights and caller rights architecture
● Use statistics tables, PL/SQL optimizer, SQLTrace, DBMSSTATS, and TKPROF to adjust performance
● Use OracleText with PL/SQL Server Pages for topic/keyword extraction, fuzzy, and wildcard searches
● Manage server-side PL/SQL Toolkit Web pages and PL/SQL Server Pages
● Protect, encrypt, and transfer data using DBMS_CRYPTO, UTLCOMPRESS, DBMS_DATA_PUMP, and DBMS_FILE_TRANSFER
This book covers all advanced topics related to PL/SQL, including many examples that can be immediately applied in your development. All examples can be obtained from the www.PLSQLBook.com or www.tupwk.com.cn/downpage sites. After downloading, simply follow the instructions to run them. The book is divided into the following six parts:
● Part I: Advanced concepts, essentials, and debugging concepts
● Part II: Caller rights, Java libraries, and object models
● Part III: Optimizing PL/SQL solutions
● Part IV: Text management using PL/SQL
● Part V: PL/SQL server home page technology and database management
● Part VI: Appendices
This is not an introductory tutorial and does not cover topics such as FOR loops, cursors, data types, or the structure of procedures, functions, and packages. If readers wish to learn about these topics, they can refer to Oracle10g PL/SQL Programming published by Oracle Press. This book covers all the prerequisite knowledge required for the advanced topics discussed in this book.