Search Results

I need help to produce output as below

1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25

my script

#!/bin/bash

for (( i = 1; i <= 5; ++i ));
do
echo -n...

If I do like this, when I run the script,it will be asking to enter value manually. And I don want this...

Enter value for list: 1234567890
old 1: select * from table where list='&list'
new ...

Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql).


cat: cannot open select
cat: cannot open *
cat: cannot open from
cat: cannot open...

Hi,

Script that I wrote only run sql query once then exit. But my requirement, I want the query can be execute a couple of time without exiting the script. How could I do it? Thanks.

Hi Sidd
Thank you for the reply. But it not works like the way I want :)

Hi Arpit,
It give error "ksh: ch: not found". Any other suggestion?thx

thrld=`bdf /u01/|grep u01|awk {'print $5'}|sed 's/'%'//'`
thrld1=`bdf /u12/|grep u02|awk {'print $5'}|sed 's/'%'//'`
ch=""

echo "------------------"
echo " "
echo...

Thank you very much ,sir ....it works now :)

count.sh#!/bin/ksh


SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3`
SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3`

LIST="Count Select_All"

select i in $LIST
do
if [ $i = "Count" ]...