CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX
page 1 of 5
Published: 19 Mar 2008
Abstract
In this article, Deepankar demonstrates the usage of Shell scripts in UNIX and their ability to run any Oracle script file. After reading this code snippet, you will be able to execute a number of oracle queries at one go without any need to wait for the end of one query to run another. This technique will be helpful for bulk insertion of records into a table.
by Deepankar Sarangi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 54521/ 237

Introduction

By using the above mentioned method, the user can run a useful oracle script through UNIX shell script. The insert script can contain millions of DML operations which can be executed at one go. Also, the prompt output can be redirected into a UNIX file for tracking any possible error in any particular DML operation.


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-04-28 12:25:16 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search