Database Reference
In-Depth Information
Instant Oracle
Database and
PowerShell How-to
Welcome to Instant Oracle Database and PowerShell How-to . In this topic you will learn how to
interact with Oracle databases from PowerShell, including connection and discovery, querying,
and modifying data and objects, and executing database logic. With the help of this topic
you can avoid manual labor and painful applications, and start leveraging the strengths of
PowerShell scripting and .NET to automate Oracle database tasks.
Setting up your environment (Simple)
Before jumping into PowerShell, make sure your system is ready to begin.
Getting ready
At a minimum, you will want the following to get started with Oracle and PowerShell:
F Accessible Oracle database: The examples in this topic are tested primarily against
the sample HR schema provided with Oracle 11g Express edition , a free download
from www.oracle.com .
F PowerShell 2.0 (or later): This is included with Windows 7 and Windows Server 2008
R2, and also available as a free download for older Windows OS versions.
F Oracle Data Access Components (ODAC): This is a free download from www.
oracle.com . Preferably use Oracle Developer Tools for Visual Studio (for later use in
this topic). Examples are tested primarily against using the 32 bit ODAC distribution.
The 64 bit version is not required for use on a 64 bit OS.
Search WWH ::




Custom Search