Buying Options
Oracle PL/SQL for DBAs
Print $39.95
Add to Cart
Print+Ebook $43.95
Add to Cart
Ebook $31.99
(PDF, ePub)
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £30.50
Add to Cart
What is this?

Oracle PL/SQL for DBAs

By
Arup Nanda, Steven Feuerstein
Publisher:
O'Reilly Media
Released:
October 2005
Pages:
456

Product Editions

  1. Oracle PL/SQL for DBAs - October 2005
  2. Mastering Oracle SQL, Second Edition - June 2004
  3. Mastering Oracle SQL - April 2002 (out of print)
Description
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. 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.
Full Description
Table of Contents

  1. Chapter 1 Introduction to PL/SQL

    1. What Is PL/SQL?

    2. Basic PL/SQL Syntax Elements

    3. Program Data

    4. Control Statements

    5. Loops in PL/SQL

    6. Exception Handling

    7. Records

    8. Collections

    9. Procedures, Functions, and Packages

    10. Querying Data

    11. Changing Data

    12. Managing Transactions in PL/SQL

    13. Database Triggers

    14. Dynamic SQL and Dynamic PL/SQL

    15. Conclusion: From Fundamentals to Applying PL/SQL

  2. Chapter 2 Cursors

    1. Reusing Cursors

    2. Using Explicit Cursors Versus Implicit Cursors

    3. Soft-Closing Cursors

    4. Using Cursors for More Than Queries

    5. Conclusion

  3. Chapter 3 Table Functions

    1. Why Table Functions?

    2. Cursors, Pipelining, and Nesting

    3. Parallelizing Table Functions

    4. Using Table Functions

    5. Table Function Examples

    6. Tips for Working with Table Functions

    7. Conclusion

  4. Chapter 4 Data Encryption and Hashing

    1. Introduction to Encryption

    2. Encryption in Oracle9i Database

    3. Encryption in Oracle Database 10g

    4. Key Management in Oracle Database 10g

    5. Transparent Data EncryptiondatabasesTransparent Data Encryption in Oracle Database 10g Release 2

    6. Cryptographic Hashing

    7. Building a Practical Encryption System

    8. Conclusion

  5. Chapter 5 Row-Level Security

    1. Introduction to RLS

    2. Using RLS

    3. RLS in Oracle Database 10g

    4. Troubleshooting RLS

    5. RLS Interactions with Other Oracle Features

    6. Application Contexts

    7. Conclusion

  6. Chapter 6 Fine-Grained Auditing

    1. Introduction to FGA

    2. Customizing FGA

    3. Administering FGA

    4. FGA in Oracle Database 10g

    5. FGA and Other Oracle Auditing Techniques

    6. The Challenge of Non-Database Users

    7. Troubleshooting FGA

    8. Conclusion

  7. Chapter 7 Generating Random Values

    1. Generating Random Numbers

    2. Generating Characters

    3. Checking for Randomness

    4. Following Statistical Patterns

    5. Conclusion

  8. Chapter 8 Scheduling

    1. Why Schedule Jobs from Within Oracle?

    2. Managing Jobs

    3. Managing the Calendar and Schedule

    4. Managing Named Programs

    5. Managing Priorities

    6. Managing Windows

    7. Managing Logging

    8. Managing Attributes

    9. Conclusion

  1. Appendix A Quick Reference

    1. DBMS_OBFUSCATION_TOOLKIT

    2. DBMS_CRYPTO

    3. DBMS_RLS

    4. DBMS_FGA

    5. DBMS_RANDOM

    6. DBMS_SCHEDULER

  2. Colophon

View Full Table of Contents
Product Details
Title:
Oracle PL/SQL for DBAs
By:
Arup Nanda, Steven Feuerstein
Publisher:
O'Reilly Media
Formats:
  • Print
  • Ebook
  • Safari Books Online
Print Release:
October 2005
Ebook Release:
June 2009
Pages:
456
Print ISBN:
978-0-596-00587-0
| ISBN 10:
0-596-00587-3
Ebook ISBN:
978-0-596-10435-1
| ISBN 10:
0-596-10435-9
Customer Reviews
About the Authors

  1. Arup Nanda

    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.

    View Arup Nanda's full profile page.

  2. Steven Feuerstein

    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.

    View Steven Feuerstein's full profile page.

  • Book cover of Oracle PL/SQL for DBAs
Got a Question?
icons
Favicon Service and support by Satisfaction