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
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Training
Appendix D Organizational Changes Required for Kanban
Appendix E EOQ vs. Kanban
Appendix I Case Study 2: Rubber Extrusion Plant
Twisted Network Programming Essentials
Responding to HTTP Requests
Storing Web Data in an SQL Database
Calling XML-RPC Functions
Calling SOAP Web Services
Logging Events and Errors
Special Edition Using Crystal Reports 10
Introduction to the Data Explorer
Connecting to COM-based Data Sources
Designing Crystal Analysis Reports and Applications
Setting Report Options
Introduction
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Creating a Struts-based MVC Application
Managing Business Logic with Struts
Building a Data Access Tier with ObjectRelationalBridge
Creating a Search Engine with Lucene
Sap Bw: a Step By Step Guide for Bw 2.0
Summary
Creating a Source System
Creating a Query Using BEx Analyzer
Transferring R/3 Global Settings
Appendix C. Glossary
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
The ROI of Lean Six Sigma for Services
Success Story #1 Lockheed Martin Creating a New Legacy
Executing Corporate Strategy with Lean Six Sigma
Phase 1 Readiness Assessment
Designing World-Class Services (Design for Lean Six Sigma)
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