hillol

Hi im a new one to shellscripting plz see the following code snippet var1=`sqlplus -S eot/eot <<- ! select ID from testhil1; quit !` echo $var1>ron cat ron vari=" " while read line do var2=` echo $line|wc -w |cut -f 1 ` vari=` echo $line ` done<"ron" echo $var2 echo …

hi, can anyone help me how to redirect sql query result to a file in shell scripting using sqlplus. Is the below code snippet corrct: sqlplus -s username/password <<- ! select * from testhil1; quit ! > rony3.txt

if i m not clear in the previous post: i have a dat file with two columns. and a database table (oracle).One field of that file nd table r same. i want to match each value of tht column of that table with that of file.pick up the correspionding other …

hi i m very new to shell script. my prob: i have a dat file and a database table(oracle). one column of that table and dat file is same. i want to replace another column of that table matching the value of the column of the table with that of …