Instant Oracle Database and PowerShell How-to

Instant Oracle Database and PowerShell How-to, 9781849688581 (1849688583), Packt Publishing, 2013

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 from this book

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.

Approach

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. Get the job done and learn as you go. This How-To guide is full of hands-on examples to get your databases automated in no time, with easy to follow code that will prove useful time and time again.

Who this book is written for

If you are a .NET developer using an Oracle Database or a regular Oracle Database user this book is full of helpful hints and tricks to automate Oracle Databases with Powershell.

Comments

Amazing Books

Dreamweaver MX: A Beginner's Guide

McGraw-Hill, 2002

Essential Skills--Made Easy!

Develop and deploy Web sites with Macromedia's unique Dreamweaver MX development environment. Get a complete introduction to this popular software's tools, features, and potent functionality. Web experts Ray West and Tom Muck will lead you through all the essentials while focusing on real-world implementation. Begin...

Underwater Robots (Springer Tracts in Advanced Robotics)

Springer, 2013

This book, now at the third edition, addresses the main control aspects in underwater manipulation tasks. The mathematical model with significant impact on the control strategy is discussed. The problem of controlling a 6-degrees-of-freedoms autonomous underwater vehicle is deeply investigated and a survey of fault detection/tolerant...

Network Infrastructure and Architecture: Designing High-Availability Networks

John Wiley & Sons, 2008

A Comprehensive, Thorough Introduction to High-Speed Networking Technologies and Protocols

Network Infrastructure and Architecture: Designing High-Availability Networks takes a unique approach to the subject by covering the ideas underlying networks, the architecture of the network elements, and the implementation of these elements in optical...

Practical Optimization Methods: With Mathematica® Applications

Springer, 2000

This introductory textbook adopts a practical and intuitive approach, rather than emphasizing mathematical rigor. Computationally oriented books in this area generally present algorithms alone, and expect readers to perform computations by hand, and are often written in traditional computer languages, such as Basic, Fortran or Pascal. This book,...

SAS for Data Analysis: Intermediate Statistical Methods (Statistics and Computing)

Springer, 2008

This book is intended for use as the textbook in a second course in applied statistics that covers topics in multiple regression and analysis of variance at an intermediate level. Generally, students enrolled in such courses are primarily graduate majors or advanced undergraduate students from a variety of disciplines. These students typically have...

Managing Globally with Information Technology

IRM Press, 2003

As the world economy becomes more interdependent and competition for business continues to be more globally oriented, it has become necessary to address the issues of IT management from a broader global focus. Information technology is not only the enabler of the global marketplace but also a potential solution base for achieving global...