Hudik G. - Instant Oracle Database and PowerShell How-to
Here you can read online Hudik G. - Instant Oracle Database and PowerShell How-to full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
Instant Oracle Database and PowerShell How-to: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Instant Oracle Database and PowerShell How-to" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
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 scriptsIn 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 Oracles Developer Tools and visualize Oracle data using Microsofts Charting library.
In the Oracle Database and PowerShell How-to youll learn all the major building blocks for automating Oracle database tasks using Microsofts 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. iPAD Amazon Kindle, PC , Cool Reader, Calibre, Adobe Digital Editions
Hudik G.: author's other books
Who wrote Instant Oracle Database and PowerShell How-to? Find out the surname, the name of the author of the book and a list of all author's works by series.
Instant Oracle Database and PowerShell How-to — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Instant Oracle Database and PowerShell How-to" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Copyright 2013 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: January 2013
Production Reference: 1180113
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84968-858-1
www.packtpub.com
Author
Geoffrey Hudik
Reviewer
Laurent Schneider
Acquisition Editor
Martin Bell
Commissioning Editor
Maria D'souza
Technical Editors
Priyanka Shah
Vrinda Amberkar
Project Coordinators
Priya Sharma
Esha Thakker
Proofreader
Aaron Nash
Production Coordinator
Melwyn D'sa
Cover Work
Melwyn D'sa
Cover Image
Conidon Miranda
Geoffrey Hudik is a developer with 14 years of experience. He has worked with a variety of companies including Alltel Information Services, JPMorgan Chase, TeamHealth, and Eventbooking.com. These days, he mostly works with C#, ASP.NET MVC and web technologies, Windows development, CTI, XAML, Oracle, SQL Server, PowerShell, Kinect, and mobile technologies including Windows Phone and iOS. He records his thoughts on his blog at http://geoffhudik.com/tech and on Twitter (@thnk2wn).
I would like to thank Jim Tilson for the expert Oracle help and general support over the years, as well as for much of the script and techniques in the recipe Automating SQL*Plus (Advanced), Additional thanks go out to Eddie Frederick, Bryant Brabson, and Jim Christopher for PowerShell assistance, general advice, and inspiration.
Laurent Schneider spends his time tuning Oracle databases and developing Oracle applications. When not working on Unix systems, he enjoys using PowerShell to start SQL*Plus scripts and to execute PL/SQL database procedures.
Laurent is working as a Senior Database Administrator for a leading wealth manager in Switzerland.
Laurent is the author of the blog, http://laurentschneider.com, and the book, Advanced Oracle SQL Programming .
When not at work, you will find Laurent playing chess tournaments or skiing in the Alps with his kids Dora and Loc.
I would like to thank Priya Sharma for her confidence and her patience. Thanks to the entire Packt Publishing team for their dedication.
You might want to visit www.PacktPub.com for support files and downloads related to your book.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
http://PacktLib.PacktPub.com
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.
- Fully searchable across every book published by Packt
- Copy and paste, print and bookmark content
- On demand and accessible via web browser
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.
Get notified! Find out when new books are published by following @PacktEnterprise on Twitter, or the Packt Enterprise Facebook page.
So why use Oracle and PowerShell together in the first place? Often there is a need to automate some work with Oracle that would be tedious to do manually in a large, graphical application such as Toad or SQL Developer. Command-line tools such as SQL*Plus exist, but do not provide the richness that PowerShell offers with its object-oriented pipeline that leverages the .NET framework and core Windows components.
PowerShell offers a lightweight yet very capable alternative to interacting with Oracle in and with Windows. It can be faster than a bloated DMBS GUI application, less work than programming an ad-hoc Oracle utility application, and more powerful than plain text shell scripting environments. PowerShell can be beneficial both for simple, ad-hoc Oracle operations and for complex scripts to automate large batch operations. You do not need to be a programmer to use it; it can be well suited for application developers, DBAs, report writers, data analysts, and other roles.
Oracle can feel more difficult on Windows in general in areas such as installation, configuration, support, stability, and tooling and this can extend to PowerShell. Secondly, unlike with SQL Server, there is no native set of PowerShell cmdlets to ease working with Oracle. With the scripting shell and database coming from competing companies, this may not change soon.
The good news is that through some elbow grease and leveraging various libraries and PowerShell's flexibility, you can manage Oracle from script without too much trouble.
Setting up your environment (Simple) , covers the prerequisites such as what you will want to have installed and configured to get started.
Accessing Oracle (Simple) , teaches you to access Oracle through loading ODP.NET and other libraries.
Connecting and disconnecting (Simple) , covers connecting with and without TNS names, TNS discovery, config file connections, secure credentials, and more.
Retrieving data (Simple) , introduces you to the basics of selecting and enumerating data using DataTables, DataReaders, and related objects.
Filtering and exporting data (Simple) , builds on the basics from retrieving data with filtering and finding data from the retrieved results and outputting it to different formats.
Adding records (Simple) , shows how to insert records and retrieve record IDs.
Importing sets of records (Medium)
Font size:
Interval:
Bookmark:
Similar books «Instant Oracle Database and PowerShell How-to»
Look at similar books to Instant Oracle Database and PowerShell How-to. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Instant Oracle Database and PowerShell How-to and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.