Oracle PL/SQL for DBAs

Overview

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills ...

See more details below
Other sellers (Paperback)
  • All (12) from $25.30   
  • New (7) from $25.30   
  • Used (5) from $25.97   
Oracle PL/SQL for DBAs

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99
BN.com price
(Save 44%)$35.99 List Price

Overview

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:

  • A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running
  • Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generation
  • Methods for DBAs to improve query and database performance with cursors and table functions
  • Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution

Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

Focused squarely on the language topics of special concern to DBAs, this text contains a quick tour of the PL/SQL language, extensive coverage of security topics, and methods for DBAs to improve query and database performance with cursors and table functions.

Read More Show Less

Product Details

  • ISBN-13: 9780596005870
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 11/28/2005
  • Edition number: 1
  • Pages: 456
  • Product dimensions: 7.02 (w) x 9.16 (h) x 1.08 (d)

Meet the Author

Arup Nanda is a Senior Oracle DBA with 10 years of experience with a variety of projects using skills in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, Pro*C, C, Unix, NT, Shell Scripting. He has an MBA from Xavier Institute of Management, India.

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992. He is currently designing and building Qnxo (www.qnxo.com), the world's first active mentoring software.

Read More Show Less

Table of Contents

Preface;
PL/SQL for DBAs;
About This Book;
Conventions Used in This Book;
About PL/SQL Versions;
Resources for Developing PL/SQL Expertise;
About the Code;
Using Code Examples;
Comments and Questions;
Safari® Enabled;
Acknowledgments;
Chapter 1: Introduction to PL/SQL;
1.1 What Is PL/SQL?;
1.2 Basic PL/SQL Syntax Elements;
1.3 Program Data;
1.4 Control Statements;
1.5 Loops in PL/SQL;
1.6 Exception Handling;
1.7 Records;
1.8 Collections;
1.9 Procedures, Functions, and Packages;
1.10 Querying Data;
1.11 Changing Data;
1.12 Managing Transactions in PL/SQL;
1.13 Database Triggers;
1.14 Dynamic SQL and Dynamic PL/SQL;
1.15 Conclusion: From Fundamentals to Applying PL/SQL;
Chapter 2: Cursors;
2.1 Reusing Cursors;
2.2 Using Explicit Cursors Versus Implicit Cursors;
2.3 Soft-Closing Cursors;
2.4 Using Cursors for More Than Queries;
2.5 Conclusion;
Chapter 3: Table Functions;
3.1 Why Table Functions?;
3.2 Cursors, Pipelining, and Nesting;
3.3 Parallelizing Table Functions;
3.4 Using Table Functions;
3.5 Table Function Examples;
3.6 Tips for Working with Table Functions;
3.7 Conclusion;
Chapter 4: Data Encryption and Hashing;
4.1 Introduction to Encryption;
4.2 Encryption in Oracle9i Database;
4.3 Encryption in Oracle Database 10g;
4.4 Key Management in Oracle Database 10g;
4.5 Transparent Data EncryptiondatabasesTransparent Data Encryption in Oracle Database 10g Release 2;
4.6 Cryptographic Hashing;
4.7 Building a Practical Encryption System;
4.8 Conclusion;
Chapter 5: Row-Level Security;
5.1 Introduction to RLS;
5.2 Using RLS;
5.3 RLS in Oracle Database 10g;
5.4 Troubleshooting RLS;
5.5 RLS Interactions with Other Oracle Features;
5.6 Application Contexts;
5.7 Conclusion;
Chapter 6: Fine-Grained Auditing;
6.1 Introduction to FGA;
6.2 Customizing FGA;
6.3 Administering FGA;
6.4 FGA in Oracle Database 10g;
6.5 FGA and Other Oracle Auditing Techniques;
6.6 The Challenge of Non-Database Users;
6.7 Troubleshooting FGA;
6.8 Conclusion;
Chapter 7: Generating Random Values;
7.1 Generating Random Numbers;
7.2 Generating Characters;
7.3 Checking for Randomness;
7.4 Following Statistical Patterns;
7.5 Conclusion;
Chapter 8: Scheduling;
8.1 Why Schedule Jobs from Within Oracle?;
8.2 Managing Jobs;
8.3 Managing the Calendar and Schedule;
8.4 Managing Named Programs;
8.5 Managing Priorities;
8.6 Managing Windows;
8.7 Managing Logging;
8.8 Managing Attributes;
8.9 Conclusion;
Appendix A: Quick Reference;
A.1 DBMS_OBFUSCATION_TOOLKIT;
A.2 DBMS_CRYPTO;
A.3 DBMS_RLS;
A.4 DBMS_FGA;
A.5 DBMS_RANDOM;
A.6 DBMS_SCHEDULER;
Colophon;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 19, 2006

    VERY VERY HIGHLY RECOMMENDED!!

    Are you a developer or database administrator? If you are, then this book is for you! Authors Arup Nanda and Steven Feuerstein, have done an outstanding job of writing a book that allows you to take advantage of the PL/SQL-based functionality in the Oracle database that is the most critical for DBAs. Nanda and Steven Feuerstein, begin by providing a whirlwind tour of the PL/SQL language, touching on all of the topics DBAs will need to become familiar with--from the basics of the PL/SQL block structure, identifier construction, and program data declarations, to the use of control and error-handling statements, to the construction of procedures, functions, packages, and triggers in PL/SQL. Then, the authors describe PL/SQL cursors and how you can improve database performance by taking advantage of such features as cursor reuse, cursor soft-parsing and soft-closing, and various characteristics of implicit cursors. Next, they explore the use of functions that can be used as data sources for queries and that are used frequently in Extraction, Transformation, and Loading (ETL) operations. The authors then explain how you can use Oracle¿s tools to build basic encryption and key management systems to protect sensitive data. They continue to explain how you can define policies on database tables so that you can restrict which rows particular users can see or change in those tables. Then, the authors show you how you can extend traditional Oracle auditing to capture both database changes and queries. Next, they discuss situations in which you may need to generate values. Finally, they describe the use of the DBMS_SCHEDULER package in scheduling jobs to be performed at regular intervals. This most excellent book is here to help you get your job done. More importantly, this book is focused squarely on the language topics of special concern to DBAs.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)