Flylib.com
Perl for Oracle Dbas
Perl for Oracle Dbas
ISBN: 0596002106
EAN: 2147483647
Year: 2002
Pages: 137
Authors:
Andy Duncan
,
Jared Still
BUY ON AMAZON
Perl for Oracle DBAs
Table of Contents
Copyright
Preface
Audience for This Book
Which Platform and Version?
Structure of This Book
About the Perl DBA Toolkit and Examples
Conventions Used in This Book
Comments and Questions
Acknowledgments
Part I: Introducing Perl for Oracle
Chapter 1. Perl Meets Oracle
Section 1.1. What is Perl?
Section 1.2. The PerlOracle Architecture
Section 1.3. Perl for Oracle DBAs
Section 1.4. For Further Information
Chapter 2. Installing Perl
Section 2.1. Installing Perl
Section 2.2. Installing Perl DBI
Section 2.3. Running Perl DBI
Section 2.4. Installing Cygwin
Part II: Extending Perl
Chapter 3. Perl GUI Extensions
Section 3.1. PerlTk
Section 3.2. OraExplain
Section 3.3. StatsView
Section 3.4. Orac
Section 3.5. DDL::Oracle
Section 3.6. SchemaDiff
Section 3.7. Senora
Section 3.8. DBD::Chart
Section 3.9. SchemaView-Plus
Section 3.10. Open Source Perl IDEs
Section 3.11. Open Source Perl GUI Debuggers
Chapter 4. Perl Web Extensions
Section 4.1. Apache
Section 4.2. Oracletool
Section 4.3. Karma
Chapter 5. Embedding Perl into Apache with mod_perl
Section 5.1. mod_perl
Section 5.2. Apache::OWA
Chapter 6. Embedded Perl Web Scripting
Section 6.1. Embperl
Section 6.2. Mason
Chapter 7. Invoking the Oracle Call Interface with Oracle::OCI
Section 7.1. What is Oracle::OCI?
Section 7.2. What Is OCI?
Section 7.3. Installing Oracle::OCI
Section 7.4. Coding with Oracle::OCI
Section 7.5. The Future of Oracle::OCI
Chapter 8. Embedding Perl into PLSQL
Section 8.1. Communication Between Perl and PLSQL
Section 8.2. Embedding Perl Within Oracle
Part III: The Perl DBA Toolkit
Chapter 9. Installing the PDBA Toolkit
Section 9.1. Introducing the PDBA Toolkit
Section 9.2. Toolkit Modules
Section 9.3. Installing the PDBA Toolkit for Unix
Section 9.4. Installing the PDBA Toolkit for Win32
Section 9.5. Configuring the PDBA Toolkit
Chapter 10. Performing Routine DBA Tasks with the PDBA Toolkit
Section 10.1. Managing User Accounts
Section 10.2. Maintaining Indexes
Section 10.3. Killing Sniped Sessions
Section 10.4. Managing Extent Usage
Section 10.5. Extracting DDL and Data
Chapter 11. Monitoring the Database with the PDBA Toolkit
Section 11.1. Monitoring the Alert Log
Section 11.2. Monitoring the Databases
Chapter 12. Building a Database Repository with the PDBA Toolkit
Section 12.1. Repository Table Structure
Section 12.2. Installing the Repository
Section 12.3. Loading the Repository with Data
Section 12.4. Reporting on Database Changes
Section 12.5. Reporting on SQL Execution Plans
Chapter 13. Extending the PDBA Toolkit
Section 13.1. Modifying a Script in the Toolkit
Section 13.2. Modifying a Module in the Toolkit
Part IV: Appendixes
Appendix A. The Essential Guide to Perl
Obtaining Online Information
Running Perl Scripts
Perl Variable Types: Scalars, Arrays, and Hashes
Perl Contexts: Void, Scalar, List, and Boolean
Program and Subroutine Parameters
Perl References
Perl s Object Orientation
Appendix B. The Essential Guide to Perl DBI
DBI Class Methods
Database Handles ?Preparation
Statement Handle Methods
Database Handles ?SQL and Cleanup
Metadata
Oracle-Specific Methods
Appendix C. The Essential Guide to Regular Expressions
The Origins of Regular Expressions
Built-in String Handling Functions
Regular Expression Concepts
Metacharacters
Match Suffixes
Appendix D. The Essential Guide to Perl Data Munging
What Is Data Munging?
Data-Munging Example: An Inter-Database Transfer
Numeric Modules
Date Modules
Conversion Modules
XML Modules
Colophon
Index
SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Perl for Oracle Dbas
ISBN: 0596002106
EAN: 2147483647
Year: 2002
Pages: 137
Authors:
Andy Duncan
,
Jared Still
BUY ON AMAZON
Crystal Reports 9 on Oracle (Database Professionals)
Oracle Advanced SELECT Options
Optimizing: The Crystal Reports Side
Optimizing: Reducing Parses
Other Tips
Appendix A Common Issues
CISSP Exam Cram 2
Equipment Life Cycle
Honeypots
Answers to Exam Prep Questions
Major Legal Systems
Symmetric Encryption
Visual C# 2005 How to Program (2nd Edition)
Self-Review Exercises
static Class Members
protected Members
Introduction
Summary
Introduction to 80x86 Assembly Language and Computer Architecture
Parts of a Computer System
Procedures
String Operations
The Assembly Process
Appendix E 80x86 Instructions (by Opcode)
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Four Precall Planning and Research
Chapter Six Defining Pain or Critical Business Issue
Chapter Eleven Gaining Access to People with Power
Chapter Fourteen Getting Started with the Process
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Understanding Digital Signal Processing (2nd Edition)
DFT FREQUENCY AXIS
THE LAPLACE TRANSFORM
THE NOTATION OF COMPLEX NUMBERS
Chapter Eleven. Signal Averaging
Appendix A. The Arithmetic of Complex Numbers
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