Instant Oracle Database and PowerShell How-to

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

Instant Oracle Database and PowerShell How-to

Geoffrey Hudik

Utilize the power of Microsoft's powerful scripting engine to automate database tasks with Oracle from PowerShell
Packt Subscription
FREE
$9.99/m after trial
eBook
$14.00
RRP $19.99
Save 29%
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$14.00
$0 p/m after trial
RRP $19.99
Subscription
eBook
Start 10 Day Trial

Frequently bought together


Instant Oracle Database and PowerShell How-to Book Cover
Instant Oracle Database and PowerShell How-to
$ 19.99
$ 14.00
Instant Creating Data Models with PowerPivot How-to Book Cover
Instant Creating Data Models with PowerPivot How-to
$ 12.99
$ 9.10
Buy 2 for $23.10
Save $9.88
Add to Cart

Book Details

ISBN 139781849688581
Paperback80 pages

Book Description

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.

What You Will Learn

  • Different ways to access Oracle from PowerShell such as ODP.NET
  • Various PowerShell tips, techniques, and samples
  • Visualize data using graphical charting tools
  • Executing and modifying database procedures
  • Running scripts in a scheduled, automated fashion with error handling
  • Automating SQL*Plus from PowerShell for complex SQL execution
  • Harnessing Oracle Developer Tools’ rich Oracle library

Authors

Book Details

ISBN 139781849688581
Paperback80 pages
Read More

Read More Reviews

Recommended for You

Instant Creating Data Models with PowerPivot How-to Book Cover
Instant Creating Data Models with PowerPivot How-to
$ 12.99
$ 9.10
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
Windows Server 2012 Automation with PowerShell Cookbook Book Cover
Windows Server 2012 Automation with PowerShell Cookbook
$ 32.99
$ 23.10
Oracle SOA BPEL Process Manager 11gR1 - A Hands-on Tutorial Book Cover
Oracle SOA BPEL Process Manager 11gR1 - A Hands-on Tutorial
$ 32.99
$ 23.10