>>Script Language and Platform: Oracle
Unix script/ Awk command for performing repetitive jobs, like creating directories from u01 u99 on an unix server.

As a DBA, many a time, I have to loop through a set of numbers for creating directories, sub directories and temporary files on unix servers.

The following shell script executes a while loop for performing the required job. (Tested the scripts on cygwin console. Pls edit your shell script, base on your unix environment)

Author: JP Vijaykumar

#!c:/cygdrive/vygwin/bin/sh

###############################

#Author JP Vijaykumar

# Oracle DBA

#Date 09-08-06

###############################

NUM=10;

while [ $NUM -lt 20 ]

do

touch temp_$NUM.dat

NUM=`expr $NUM + 1`

done

exit



----------------------------------------------------------------------------------------



This one line awk script does what the earlier shell script handles (The power of awk)

$ awk 'BEGIN {for (i=10;i<20;i++) {print "touch temp_"i".dat"} exit}'|sh

          submitted by: JP Vijaykumar Hits : 0 :: Rating: 0 :: Votes: 0 

Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose... Disclaimer Continued

Back to Database Journal Home