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
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP System Acquisition: A Process Model and Results From an Austrian Survey
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Context Management of ERP Processes in Virtual Communities
Intrinsic and Contextual Data Quality: The Effect of Media and Personal Involvement
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
CISSP Exam Cram 2
LAW, INVESTIGATIONS, AND ETHICS
Answers to Exam Prep Questions
Message Privacy
The System Development Life Cycle
Exam Prep Questions
C++ GUI Programming with Qt 3
Using Dialogs
Integrating Custom Widgets with Qt Designer
Widget Stacks
Multiple Document Interface
UDP Networking with QSocketDevice
MySQL Cookbook
Issuing Queries
Performing Leap Year Calculations
Summarizing with COUNT( )
Using Patterns to Match Dates or Times
Introduction
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 285 Transient Voltage Surge Suppressors (TVSSs)
Article 354 Nonmetallic Underground Conduit with Conductors Type NUCC
Article 382 Nonmetallic Extensions
Article 411: Lighting Systems Operating at 30 Volts or Less
Tables 12(A) and 12(B)
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
VBScript Basics
Processing Collections of Data
Combining Different Scripting Languages
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