Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering Oracle PL/SQL: Practical Solutions


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

  1. Efficient PL/SQL
  2. Package It All Up
  3. The Vexed Subject of Cursors
  4. Effective Data Handling
  5. PL/SQL Optimization Techniques
  6. Triggers
  7. DBA Packages
  8. Security Packages
  9. Web Packages
  10. PL/SQL Debugging
(HTML tags aren't allowed.)

Efficient Approximation and Online Algorithms: Recent Progress on Classical Combinatorial Optimization Problems and New Applications
Efficient Approximation and Online Algorithms: Recent Progress on Classical Combinatorial Optimization Problems and New Applications
This book provides a good opportunity for computer science practitioners and researchers to get in sync with the current state-of-the-art and future trends in the field of combinatorial optimization and online algorithms. Recent advances in this area are presented focusing on the design of efficient approximation and on-line algorithms. One central...
Moments and Moment Invariants in Pattern Recognition
Moments and Moment Invariants in Pattern Recognition

Automatic object recognition has become an established discipline in image analysis. Moments and moment invariants play a very important role as features in invariant recognition. They were introduced to the pattern recognition community almost 50 years ago and the mathematical background they utilized is even older, originating from the...

High Tech/High Touch: Technology and Our Search for Meaning
High Tech/High Touch: Technology and Our Search for Meaning
The one great megatrend of the new millennium. In this important and timely book encompassing the key trends of our time, John Naisbitt, the world's foremost social forecaster and bestselling author, takes us on a compelling and kaleidoscopic tour of our contemporary 'technology immersion' and our accelerated search for meaning. High...

Hardening Apache
Hardening Apache

A must-read for any system administrator installing or currently using Apache, Hardening Apache shows you exactly what to do to make Apache more secure. Throughout this book, renowned author Tony Mobily introduces you to many of the security problems you’ll inevitably stumble across when using Apache---and most important,...

PowerPoint 2007 Bible
PowerPoint 2007 Bible

Creating a good presentation is much more than just clicking a few dialog boxes and typing some text. It requires knowledge and planning-lots of it. With the PowerPoint 2007 Bible you will not only be able to build a presentation with PowerPoint, but you’ll also be able to explain why you made the choices you did, and you’ll...

Sensing, Intelligence, Motion : How Robots and Humans Move in an Unstructured World
Sensing, Intelligence, Motion : How Robots and Humans Move in an Unstructured World

A leap forward in the field of robotics

Until now, most of the advances in robotics have taken place in structured environments. Scientists and engineers have designed highly sophisticated robots, but most are still only able to operate and move in predetermined, planned environments designed specifically for the robots and

©2019 LearnIT (support@pdfchm.net) - Privacy Policy