You are previewing Instant Oracle Database and PowerShell How-to.
O'Reilly logo
Instant Oracle Database and PowerShell How-to

Book Description

Utilize the power of Microsoft's powerful scripting engine to automate database tasks with Oracle from PowerShell

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results.

  • Load Oracle Data Access components and connect to Oracle databases

  • Retrieve, format, filter, and export data

  • Execute database procedures and modify database objects

  • Build Oracle script libraries and run automated, unattended scripts

  • In Detail

    PowerShell provides a rich, object-oriented scripting language that can be used to perform a number of Oracle database tasks. It can be harnessed to automate manual tasks in graphical database management systems or go beyond what can be done in Oracle-only command line shells.

    Oracle and PowerShell will walk you through scripting a number of common Oracle database tasks with real-world code examples and detailed explanations so you can automate operations without manual labor or writing custom utility applications.

    This book will start with accessing Oracle and retrieving and modifying data, and will build up to more involved operations, building a reusable script library along the way.

    You will also see how to execute and modify database procedures from PowerShell, run unattended, scheduled scripts, and automate database deployments using Oracle command line tools from PowerShell. Finally you will learn how to tap into a powerful library in Oracle's Developer Tools and visualize Oracle data using Microsoft's Charting library.

    In the Oracle Database and PowerShell How-to you'll learn all the major building blocks for automating Oracle database tasks using Microsoft's rich scripting language.

    Table of Contents

    1. Instant Oracle Database and PowerShell How-to
      1. Instant Oracle Database and PowerShell How-to
      2. Credits
      3. About the Author
      4. About the Reviewer
      5. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
          3. Instant Updates on New Packt Books
      6. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      7. 1. Instant Oracle Database and PowerShell How-to
        1. Setting up your environment (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        2. Accessing Oracle (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Getting help with ODP.NET
            2. Loading ODP.NET 4.0
            3. Using OLE DB
            4. Using Microsoft's Data Provider for Oracle
            5. Other ways to access Oracle
        3. Connecting and disconnecting (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Connecting with TNS Names
            2. Reading connection strings from config files
            3. Prompting for connection credentials
        4. Retrieving data (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Unrolling and null checking
            2. Using a DataReader
        5. Filtering and exporting data (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Exporting to HTML
        6. Adding records (Simple)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Importing sets of records (Medium)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Using array binding for bulk inserts
        8. Updating and deleting records (Simple)
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Updating with a DataAdapter
        9. Executing database procedures (Medium)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Invoking a function
        10. Organizing and invoking scripts (Medium)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. The PowerShell profile
        11. Script automation and error handling (Medium)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        12. Creating reusable script modules (Advanced)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        13. Automating SQL*Plus (Advanced)
          1. Getting ready
          2. How to do it...
          3. How it works...
        14. Exploring ODT assemblies (Advanced)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        15. Visualizing data (Advanced)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...