hrs Specialised Training to meet your needs

Using Perl and Perl DBI with Oracle

Assumptions and pre-requisites

Course Outline

• Introduction
  • Perl
    • What is it
    • History
    • Data types
      • Scalar
      • List (array)
      • Hash
    • Object oriented perl
  • SQL
    • Why?
    • History
    • Data types
      • Text
      • Numeric
      • Boolean
      • Date
      • LOB
    •  
     
  • DBI Architecture
    • DBI
      • DataBase Independent
      • Uniform interface for all driver modules
      • Routes all calls to the drivers for implementation
      • Implements many default methods
    • DBD Module
      • DataBase Dependent
      • Database dependant code
      • Contains implementation-specific methods defined by DBI
    •  
     
• Getting started
  • Installing perl
    • Building from source
    • Finding binary distributions
    • Extending Perl with CPAN
      • Using the CPAN shell
      • ActiveState for Windows
  • Installing DBI
    • Requirements
      • Database not included!
    • Testing the installation
  • DBD Modules
    • Drivers included with DBI
      • ADO
      • CVS
      • DBM
    • Additional modules available
      • Oracle
      • PostgreSQL
      • mySQL
      • and more...
    • Finding DBD modules
      • CPAN
      • Vendor specific
        • IBM DB2
• Basics
  • use DBI;
    • Importing the namespace
  • Data sources
    • Using DBI->available_drivers() to find drivers
  • Handles
    • Driver handle
    • Database handle
    • Statement handle
  • Connections
    • Creating a database handle with DBI->connect()
  •  
   
• Using DBI
  • Non-query statements
    • The quote() function
    • $dbh->do()
    • Using the return value to find errors
  • Queries
    • Preparing the statement
    • Executing
    • Fetching rows
  • Binding parameters
    • Bind efficiencies
    • Binding perl variables to input values
    • Using bind_param() to specify a data type
  • Binding output
    • Binding output values to perl variables
    • Using bind_param_inout() with stored procedures
  • Batch fetching
    • Difference between arrayref and hashref
    • fetchall_arrayref()
    • fetchall_hashref()
    • Slice array references
    • Using selectall_arrayref() in a single step
  •  
   
• Advanced
  • Handle attributes
  • Error handling
  • LOBs
  • Transactions

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003