Geek Articles

Categories

 

Subscribe

Daily Updates Subscribe geekarticles update via email Subscribe geekarticles update via RSS

 
GeekArticles Microsoft ASP.NET

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

Author: aspalliance.com | Published: 19th Mar 2008 | Visited: 73 times | Add Comment
Filed in: ASP NET

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.

Read Article
 

Sponsored Links

 


Related Articles

 Speeding Up Post Load Script Post-load script maybe one of the most challenging tasks for developers especially those that use a framework for building an Ajax application. In a framework setting, developers will always work in a setting wherein JavaScript is involved. When post load happens, developers will be limited in thei ...

 Using Oracle XML DB Repository Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository, which is an essential component of Oracle XML ...

 Querying Data with Oracle XQuery Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2, you can take advantage of a full-featured native XQuery engine integrated with the database. With Oracle XQuery, you can accomplish various tasks involved in developing PHP/Oracle XML applications, operating on any kind of ...

 CodeSnip: Using Dynamic Cursor in a Procedure Using Oracle 9i In this code snippet, Deepankar examines the usage of dynamic cursors in a procedure where the table name is passed as an input parameter. After listing the SQL code sample, he analyzes it and then provides a screenshot of the final out ...

 Using Oracle EPG to provide XML services for Adobe Flex applications Learn how to use the Embedded PL/SQL Gateway framework to create your Flex a ...

 Integrating Oracle's Hyperion Essbase - System 9 with Oracle Business Intelligence A step-by-step guide to using Oracle's Hyperion Essbase - System 9 as a back end for Oracle Business Intelligence Suite Enterprise Edit ...

 A C++ Config File Parser An STL based C++ utility class to parse structured config fi ...

 How to burn optical file images with IMAPI 2.0 from managed code Burn ISO files using IMAPI v2.0 and ...

 A C++ Config File Parser STL based C++ utility class to parse structured config f ...

 Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...



Next: CodeSnip: How to Create an Oracle Insert Script Using Substitution Function in UNIX?



Post Comment

Name:


Email:
 (Optional. Used for Notification)

Title:

 
Comment:


Validation Code:
 <=>  (Enter this code in text box)





Latest Articles

 

Popular Articles

Sponsored Links