CodeSnip: How to Create an Oracle Insert Script Using Substitution Function in UNIX?
page 1 of 4
Published: 17 Mar 2008
Abstract
This article examines the creation of an insert script in Oracle by making use of the substitution function in UNIX. Deepankar begins with a short introduction followed by the various parameters of the function. The author provides a detailed analysis of the code along with relevant screenshots.
by Deepankar Sarangi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20047/ 87

Introduction

By using the above mentioned method, a user can create a useful insert script for inserting millions of records into a table in oracle. When the user is provided with millions of records to insert into a table, they can be easily inserted through an insert script comprising of an equal number of insert statements. The use of SQL loader can make the task easy, but the goal can be achieved even without it. This method can be taken as a substitution for SQL loader. It uses a substitution utility of UNIX.


View Entire Article

User Comments

Title: use sql loader   
Name: culon
Date: 2008-03-18 7:44:34 PM
Comment:
use oracle sqlloader , it is MUCH faster

Product Spotlight
Product Spotlight 





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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-10-08 9:02:41 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search