Synopses & Reviews
There is ample evidence from community discussion lists that many developers really struggle when it comes to actually applying PL/SQL stored procedures to their real world problems. There are several books on the market that teach the PL/SQL language and will dedicate a few chapters to the fundamental of stored procedures. However, Oracle Stored Procedures Applied will help take them to the next level. It shows clearly the sort of problems that can (and should) be solved using stored procedures, and how to code them effectively. It focuses exclusively on real practical uses of PL/SQL in the database - as a highly efficient data handling language, as a database administration tool, a web development language, a security mechanism and more. It also shows how to exploit the versatile functionality of Java stored procedures, right in the database, to extend the capabilities of PL/SQL.No other book on the market is written at such a totally practical level. 7Has broad appeal to both Oracle developers and DBAs (whose programming environment is the database) and to Java developers who use the Oracle database and need to know how to program PL/SQL and Java (Oracle supports Java stored procedures) in the database.7Has a deeply practical approach that will enable developers to take the step from knowing the PL/SQL language to truly understanding how to effectively implement it in the database.7Based on extensive input from popular discussion lists, and will recommend best practice approaches to the most common problems with which developers struggle.7Written by recognized experts who the community will want to listen to. Each chapter is written by an experienced expert in the field. For exampleConnor McDonald, winner of BMC's international SmartDBA competition in 2002, and host of the highly regarded oracledba.co.uk site writes the PL/SQL best practices chapter; David Knox, security guru at Oracle Corp., writes the Security packages chapter; Joel Kallman, one of the key developers behind "Project Marvel" (which powers the asktom.oracle.com site) writes the web packages chapter. 7Gives field-tested examples of effective use of Oracle 9i features. Many 9i sites still use code that would compile on Oracle7, either out of habit or because they do not understand how to correctly apply the new features.7Provides real solutions that people can then build upon themselves, as opposed to the usual simplified code snippets.
Mastering Oracle PL/SQL: Practical Solutions isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It will show you how to write code that will run quickly and won't break in high load, multi-user environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.
Do you need more from a PL/SQL book than just the correct keywords and some pretty syntax diagrams? Have you been searching in vain for real-world examples and genuine strategies for maximizing the benefits of PL/SQL within your organization? You'll find them here in Mastering Oracle PL/SQL: Practical Solutions, the inaugural title of the pioneering OakTable Press series from Apress.
This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.
This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. The practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects.
If you're brand-new to PL/SQL, then you'll want to take some time to get familiar with the language before tackling this book. It's not for the total beginner. But once youre up and running, you'll find this book an invaluable guide for ensuring that the PL/SQL solutions you build are robust, perform well, and are easy to maintain. What you?ll learn Who this book is for
Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively. Table of Contents Efficient PL/SQL Package It All Up The Vexed Subject of Cursors Effective Data Handling PL/SQL Optimization Techniques Triggers DBA Packages Security Packages Web Packages PL/SQL Debugging
PL/SQL is the procedural programming language of choice in the Oracle database. It is completely integrated with SQL and is the most fully optimized, highest performance language for database transaction processing.
This book is about cool, effective techniques to solve essential problems using PL/SQL. It does not attempt to teach the language - there are plenty on the market that do that - instead it focuses in on the fundamental programming unit, the stored procedure, and demonstrates how to code them in the most effective manner and on real practical uses for them in the database.
In short: if you have mastered the fundamentals of the PL/SQL language, and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you. It will demonstrate how to:
- Design efficient, high performance PL/SQL code
- Implement effective data handling mechanisms
- Streamline your database administration
- Work with Triggers
- Secure your data
- Build effective web applications that run from the database
- Exploit the versatile functionality of Java right in the database
- Debug and optimize PL/SQL
This book is targeted primarily at the Oracle DBA or developer charged with the implementation of effective data handling and database administration mechanisms, but will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL in order to distribute their application code effectively.
Table of Contents
Designing Efficient PL/SQL.- Data Handling.- Triggers.- DBA Packages.- Security Packages.- Web Packages.- Java Stored Procedures.- Using UDTs and UDFs.- Debugging.- Testing and Tuning.