| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Frequently Bought Together
Product details
|
Product Description
Product Description
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
About the Author
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
The contents, that goes without saying, are really interesting, and I've already used the improved knowledge and new facts that I've got from the book for my code and designs. Most importantly, I know, given the Author's reputation and method (always try things out and then provide a test case), that what's in the book is correct and works - which, sadly, does not apply for too many books about Oracle out there.
The book now is included in my "gold quality" bookshelf. Since this bookshelf is composed exclusively by books authored by Thomas Kyte, Jonathan Lewis, Steve Adams, Cary Millsap, James Morle, and now Connor McDonald, who are members of the OakTable Network (which i've nicknamed the "Oracle Scientist Club", since in essence, the reason why they are so succesfull it's that they follow the aforementioned method in investigating Oracle), I'm really sure that the "OakTable Press Series" is not to be missed, and I won't miss for sure. Great!
From a Java and Sybase (T-SQL) developer moving to Oracle, this book was the one that I kept reaching for. Covering everthing from basic instructions on SQL and PL/SQL to more Oracle/DB based issues of triggers, sequences, procs, functions and optimizing and tuning. It is al written in an easy to understand but not patronising tone, in a great layout.
Far easier to read and learn from than all the Oracle books I've come across.
One of this book's strengths is explaining 'thinking outside the box' ideas and insights for squeezing every ounce of use from PL/SQL. One useful trick it's taught me is the ability to tie job submission to a transaction via a trigger. This would allow you to launch a task requiring major processing from a simple transaction, without having to wait for the task to complete. If the simple transaction is rolled back, the job will not be submitted. It's kind of obvious if you think about it, but personally I never did. I'm sure I'm not the only one either. This book is full of tips like that.
Every chapter is clearly and concisely written; the big focus being on proof by example. Anyone who's not brushed up on PL/SQL since Oracle 7 and 8 would do well to give it a read, as it covers all the notable new features of the language up to 10g. For example, if bulk collection and bulk binding are unfamiliar concepts to you and you're still using Cursor For Loops and row by row processing, you would really benefit from reading this book (along with your code performance).
I've not yet reached the section on debugging, but given the abilities of this author to come up with useful surprises, I'm looking forward to what I might find. I'm guessing it won't be the obvious. ;o)
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
