Instant Oracle Database and PowerShell How-to

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

Overview

• 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.

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.

利用微軟強大的腳本引擎，從PowerShell自動化Oracle的資料庫任務

概述
- 立即學習新知識！一本短小、快速、專注的指南，能夠立即產生效果。
- 載入Oracle數據訪問組件並連接到Oracle數據庫。
- 檢索、格式化、過濾和導出數據。
- 執行數據庫程序並修改數據庫對象。
- 構建Oracle腳本庫並運行自動化的無人值守腳本。

詳細內容
PowerShell提供了一種豐富的面向對象的腳本語言，可用於執行多種Oracle數據庫任務。它可以用於自動化圖形化數據庫管理系統中的手動任務，或超越僅能在Oracle命令行界面中完成的任務。

《Oracle和PowerShell》將引導您使用真實代碼示例和詳細解釋來腳本化一些常見的Oracle數據庫任務，以便您可以在不需要手動操作或編寫自定義實用程序的情況下自動執行操作。

本書將從訪問Oracle和檢索、修改數據開始，逐步進行更複雜的操作，並在此過程中建立可重用的腳本庫。

您還將學習如何從PowerShell執行和修改數據庫程序，運行無人值守的定時腳本，以及使用Oracle命令行工具從PowerShell自動化數據庫部署。最後，您將學習如何利用Oracle的開發工具庫和微軟的圖表庫來視覺化Oracle數據。

在《Oracle數據庫和PowerShell How-to》中，您將學習使用微軟豐富的腳本語言自動化Oracle數據庫任務的所有主要構建塊。

本書適合對象
- 如果您是使用Oracle數據庫的.NET開發人員或常規Oracle數據庫用戶，本書充滿了有用的提示和技巧，可幫助您使用PowerShell自動化Oracle數據庫。