Flylib.com
Oracle PL(s)SQL For DBAs
Oracle PL(s)SQL For DBAs
ISBN: N/A
EAN: N/A
Year: 2005
Pages: 122
BUY ON AMAZON
Oracle PLSQL for DBAs
Table of Contents
Copyright
Preface
PLSQL for DBAs
About This Book
Conventions Used in This Book
About PLSQL Versions
Resources for Developing PLSQL Expertise
About the Code
Using Code Examples
Comments and Questions
Safari Enabled
Acknowledgments
Chapter 1. Introduction to PLSQL
Section 1.1. What Is PLSQL?
Section 1.2. Basic PLSQL Syntax Elements
Section 1.3. Program Data
Section 1.4. Control Statements
Section 1.5. Loops in PLSQL
Section 1.6. Exception Handling
Section 1.7. Records
Section 1.8. Collections
Section 1.9. Procedures, Functions, and Packages
Section 1.10. Querying Data
Section 1.11. Changing Data
Section 1.12. Managing Transactions in PLSQL
Section 1.13. Database Triggers
Section 1.14. Dynamic SQL and Dynamic PLSQL
Section 1.15. Conclusion: From Fundamentals to Applying PLSQL
Chapter 2. Cursors
Section 2.1. Reusing Cursors
Section 2.2. Using Explicit Cursors Versus Implicit Cursors
Section 2.3. Soft-Closing Cursors
Section 2.4. Using Cursors for More Than Queries
Section 2.5. Conclusion
Chapter 3. Table Functions
Section 3.1. Why Table Functions?
Section 3.2. Cursors, Pipelining, and Nesting
Section 3.3. Parallelizing Table Functions
Section 3.4. Using Table Functions
Section 3.5. Table Function Examples
Section 3.6. Tips for Working with Table Functions
Section 3.7. Conclusion
Chapter 4. Data Encryption and Hashing
Section 4.1. Introduction to Encryption
Section 4.2. Encryption in Oracle9i Database
Section 4.3. Encryption in Oracle Database 10g
Section 4.4. Key Management in Oracle Database 10g
Section 4.5. Transparent Data Encryption in Oracle Database 10g Release 2
Section 4.6. Cryptographic Hashing
Section 4.7. Building a Practical Encryption System
Section 4.8. Conclusion
Chapter 5. Row-Level Security
Section 5.1. Introduction to RLS
Section 5.2. Using RLS
Section 5.3. RLS in Oracle Database 10g
Section 5.4. Troubleshooting RLS
Section 5.5. RLS Interactions with Other Oracle Features
Section 5.6. Application Contexts
Section 5.7. Conclusion
Chapter 6. Fine-Grained Auditing
Section 6.1. Introduction to FGA
Section 6.2. Customizing FGA
Section 6.3. Administering FGA
Section 6.4. FGA in Oracle Database 10g
Section 6.5. FGA and Other Oracle Auditing Techniques
Section 6.6. The Challenge of Non-Database Users
Section 6.7. Troubleshooting FGA
Section 6.8. Conclusion
Chapter 7. Generating Random Values
Section 7.1. Generating Random Numbers
Section 7.2. Generating Characters
Section 7.3. Checking for Randomness
Section 7.4. Following Statistical Patterns
Section 7.5. Conclusion
Chapter 8. Scheduling
Section 8.1. Why Schedule Jobs from Within Oracle?
Section 8.2. Managing Jobs
Section 8.3. Managing the Calendar and Schedule
Section 8.4. Managing Named Programs
Section 8.5. Managing Priorities
Section 8.6. Managing Windows
Section 8.7. Managing Logging
Section 8.8. Managing Attributes
Section 8.9. Conclusion
Appendix A. Quick Reference
Section A.1. DBMS_OBFUSCATION_TOOLKIT
Section A.2. DBMS_CRYPTO
Section A.3. DBMS_RLS
Section A.4. DBMS_FGA
Section A.5. DBMS_RANDOM
Section A.6. DBMS_SCHEDULER
About the Author
Colophon
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Oracle PL(s)SQL For DBAs
ISBN: N/A
EAN: N/A
Year: 2005
Pages: 122
BUY ON AMAZON
Crystal Reports 9 on Oracle (Database Professionals)
Oracle SQL
Oracle Advanced SELECT Options
Optimizing: The Crystal Reports Side
Data Dictionary Report
Appendix A Common Issues
Developing Tablet PC Applications (Charles River Media Programming)
Introduction to the VB .NET Language
Introduction to Ink-Enabled Applications
Creating an MP3 Player
Getting Started with Microsoft Agent
Pong Game
Introduction to 80x86 Assembly Language and Computer Architecture
Elements of Assembly Language
Basic Instructions
Branching and Looping
Floating-Point Arithmetic
Decimal Arithmetic
Information Dashboard Design: The Effective Visual Communication of Data
Arranging the Data Poorly
Gestalt Principles of Visual Perception
Applying the Principles of Visual Perception to Dashboard Design
Sample Marketing Analysis Dashboard
A Final Word
Junos Cookbook (Cookbooks (OReilly))
Configuring the Router by Copying a File from a Server
Managing Routers with Similar Configurations
Creating a Privilege Class that Hides Encrypted Passwords
NTP
Introduction
Comparing, Designing, and Deploying VPNs
Review Questions
Review Questions
IPsec: A Security Architecture for IP
Deploying IPsec VPNs: Fundamental Considerations
Scaling and Optimizing IPsec VPNs
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies