CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
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): 65994/ 104

Article Contents:

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

(Page 2) »

User Comments

No comments posted yet.

Product Spotlight