Books & Videos

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