Perl for Oracle Dbas
Perl for Oracle Dbas
ISBN: 0596002106
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 137
Pages: 137
Authors: Andy Duncan, Jared Still
- 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
EAN: 2147483647
Year: 2002
Pages: 137
Pages: 137
Authors: Andy Duncan, Jared Still