Oracle PL/SQL for DBAs
Buy a book... In Association with Amazon.co.uk
Author(s): A. Nanda and S. Feuerstein
Publisher: O'Reilly
ISBN: 0596005873
Format: softback
429pp
Price: £28.50
Review Date: 10 February 2006
Review: Millions of developers and database administrators (DBAs) around the world use Oracle software to build complex systems that manage vast amounts of data. At the heart of this software is PL/SQL. This is a programming language that provides procedural extensions to Oracle’s version of Structured Query language (SQL) and serves as the programming language within the Oracle developers’ toolset. This book will help you to take advantage of the PL/SQL-based functionality in the Oracle database, covering the latest Oracle version, Oracle Database 10g Release 2. It begins with an introduction to PL/SQL and goes on to look at security topics for DMAs – encryption, Row-Level Security, Fine-Grained Auditing, and random value generation. Methods for DBAs to improve query and database performance with cursors and table functions are described. Oracle scheduling is also covered. This allows tasks such as database monitoring and statistics gathering to be scheduled for regular execution.