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
Agile Project Management: Creating Innovative Products (2nd Edition)
The Business of APM
An Agile Process Framework
Judgment Required
A Hub Organizational Structure
Reliable Innovation
High-Speed Signal Propagation[c] Advanced Black Magic
The Concept of Resonance
Limits to Attainable Distance
Modeling Vias
Laying Cables in an Uncooled Attic Space
150-Ohm STP-A Cabling
Adobe After Effects 7.0 Studio Techniques
Animation Methods
Blending Modes: The Real Deal
Film and Video Looks
Expressions
Video Gamma Space
MySQL Clustering
Adding Tables
Backup and Recovery
Security for MySQL Cluster
Data Retrieval in MySQL Cluster
B Management Commands
Cisco IOS Cookbook (Cookbooks (OReilly))
Partitioning Flash
Static Routes That Track Interfaces or Other Routes
Using Multipoint Subinterfaces
Restricting What Log Messages Are Sent to the Server
Adjusting NAT Timers
The Java Tutorial: A Short Course on the Basics, 4th Edition
Code Samples
Numbers
Questions and Exercises
Summary of Reading and Writing
Integrated Development Environments
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