CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX
page 1 of 5
Published: 19 Mar 2008
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
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 67614/ 71


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-2024  |  Page Processed at 2024-06-15 3:40:52 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search