Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Instant Oracle Database and PowerShell How-to

Buy

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.

(HTML tags aren't allowed.)

Understanding SCA (Service Component Architecture)
Understanding SCA (Service Component Architecture)

Use SCA to Simplify the Development and Delivery of Service-Based Applications

 

Service Component Architecture (SCA) is a new programming model that enables developers to build distributed applications more efficiently and effectively than previous...

Master Humphrey's Clock
Master Humphrey's Clock
THE reader must not expect to know where I live. At present, it is true, my abode may be a question of little or no import to anybody; but if I should carry my readers with me, as I hope to do, and there should spring up between them and me feelings of homely affection and regard attaching something of interest to matters ever so slightly connected...
Misunderstanding the Internet (Communication and Society)
Misunderstanding the Internet (Communication and Society)

The growth of the internet has been spectacular. There are now more 1.5 billion internet users across the globe, about one quarter of the world’s population. This is certainly a new phenomenon that is of enormous significance for the economic, political and social life of contemporary societies.

However, much popular and...


SQL Server 2017 Integration Services Cookbook: Powerful ETL techniques to load and transform data from almost any source
SQL Server 2017 Integration Services Cookbook: Powerful ETL techniques to load and transform data from almost any source

Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease

About This Book

  • Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services
  • Program and extend your packages to enhance their...
Posters: A Global History
Posters: A Global History
From band posters stapled to telephone poles to the advertisements hanging at bus shelters to the inspirational prints that adorn office walls, posters surround us everywhere―but do we know how they began? Telling the story of this ephemeral art form, Elizabeth E. Guffey reexamines the poster’s roots in the nineteenth century and...
Smashing WordPress: Beyond the Blog (Smashing Magazine Book Series)
Smashing WordPress: Beyond the Blog (Smashing Magazine Book Series)

Smashing WordPress shows you how to utilize the power of the WordPress platform, and provides a creative spark to help you build WordPress-powered sites that go beyond the obvious. The second edition of Smashing WordPress has been updated for WordPress 3.1+, which includes internal, custom post types, the admin bar, and lots of other...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy