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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Overview of Java UI Toolkits and SWT/JFace
Jump Start with SWT/JFace
Other Important SWT Components
Printing
JFace Windows and Dialogs
WebLogic: The Definitive Guide
Virtual Hosting
Using JNDI and RMI
Clustering and JDBC Connections
Configuring JMS Resources
The Providers
Systematic Software Testing (Artech House Computer Library)
An Overview of the Testing Process
Detailed Test Planning
Test Execution
The Software Tester
Appendix B Testing Survey
Data Structures and Algorithms in Java
Summary
Projects
Binary Search Trees
Problems
Summary
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Tcpdump
IDS and IPS Internals
Internet Security Systems RealSecure
Incident Response
Policy and Procedures
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
The Internationalization of the Retail Supply Chain
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
Transforming Technologies: Retail Exchanges and RFID
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