CodeSnip: How to Create an Oracle Insert Script Using Substitution Function in UNIX?
page 3 of 4
by Deepankar Sarangi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20101/ 29

Substitution Functions in UNIX

This is a VI editor command specific to UNIX operating system. It is usually used to substitute texts in VI editor. The basic formula is described below.

parameter1,parameter2s/parameter3 (text to be altered or location involved)/parameter4(final text to be put)

parameter1: Indicates the first line from which the substitution will take place.

0/1 indicates the first line of any file in VI editor. 2 indicate the second line and so on.

Parameter2: Indicates the last line up to which the substitutions will occur. (the count of the final line)

S: Stands for the substitution.

Parameter3: Indicates the part of the text in each line to be substituted or the place of substitution (usually prior to the beginning (^) or after end ($) of the line).

Parameter4: This indicates the final text that the user wishes to put in desired places.

View Entire Article

User Comments

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

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2024  |  Page Processed at 2024-04-13 10:20:14 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search