Shell Programming and Scripting

#!/bin/bash
if [ $# -ne 2 ]
then
  exit 1
else
	for linea in $1
	do 
		telefono=`echo $linea | cut -d"#" -f 3`
		server=`echo $STRING |cut -d '#' -f1`
		user=`echo $STRING |cut -d '#' -f2`
		password=`echo $STRING |cut -d '#' -f3`
		sqlplus -s $user/$PASSWORD @$xxxxxxxxxxx/xxxxxxxxxxx.sql >> $xxxxxxxx/xxxxxx.dat
	done
fi

#!/bin/bash
if [ $# -ne 1 ]
then
  exit 1
else
        while read linea
        do
                telefono=`echo $linea | cut -d"#" -f3`
                server=`echo $linea |cut -d '#' -f1`
                user=`echo $linea |cut -d '#' -f2`
                password=`echo $linea |cut -d '#' -f3`
                sqlplus -s $user/$password @$xxxxxxxxxxx/xxxxxxxxxxx.sql $telefono >> $xxxxxxxx/xxxxxx.dat
        done < $1
fi

SELECT * FROM hello WHERE hello.num = '&1'

qnum="("

while IFS="#" read f1 f2 f3 skip
do
        qnum="${qnum}'$f3',"
done < fileToRead

qnum="${qnum})"

qnum=$( echo "$qnum" | sed 's/,)$/)/' )               # remove trailing comma

sqlplus -s $user/$PASSWORD << EOF >> xxxxxx.dat
set echo off head off feed off pagesize 0 trimspool on linesize 1000
select * FROM hello
WHERE hello.num in ${qnum};
exit
EOF

#!/bin/bash

#If the number of variables is two leaves
if [ $# -ne 2 ]
then
  exit 1
else
    #read row by row in the parameter file
    for linea in $1
    do 
        telefono=`echo $linea | cut -d"#" -f 3`
        #declares an array to store all the variables of each of the lines in a file
        set -A numeros_telefonos $telefono
    done

    #Connect the database
     ==> ¿¿¿¿?????
    
    #for each phone number is found in the corresponding table and dumps the contents in its corresponding output file
    for i in ${numeros_telefonos[*]}
    do 
        #name the file. sql and dump the information to an output file
        ==> ¿¿¿????
        ==> ¿¿¿fich_dat=${i}???
        
    done 
#fin del if de entrada 
fi

SPOOL tramiT.dat
SELECT * FROM hello WHERE  xxx = '&1' 
SPOOL OFF;
/
QUIT;

#!/bin/bash
# populate the numeros_telefonos array with all telephon numbers
for linea in $( cat $1 )
do
telefono=`echo $linea | cut -d"#" -f 3`
numeros_telefonos=("${numeros_telefonos[@]}" "$telefono")
done

#loop on array
for i in ${numeros_telefonos[@]}
do
#for each entry in array execute file.sql with telephon number as parameter
sqlplus -L -s user/password@server @ file.sql $i >> tramiT.dat
done

set ver off
set heading off
set pause off
SET FEEDBACK  OFF
SET ECHO      OFF
SET TERM      ON
SET TRIMOUT   ON
SET TRIMSPOOL ON
SET PAGESIZE 0
SET linesize 500
SELECT * FROM hello WHERE xxx = '&1';
QUIT;

#!/bin/ksh
if [ $# -ne 1 ]
then
echo "SALIDA FORZADA"
  exit 1
else
  for linea in $(cat $1) 
  do
     telefonos=`echo $linea | cut -d"#" -f 3`
     numeros_telefonos[$i]=$telefonos
  done 
  #loop on array
  for i in ${numeros_telefonos[@]}
 do
 #for each entry in array execute file.sql with telephon number as parameter
     sqlplus user/pass @file.sql $i >> tramiT.dat
        done
fi

    sqlplus user/pass
        #loop on array
        for i in ${numeros_telefonos[@]}
        do
            #for each entry in array execute file.sql with telephon number as parameter
             @file.sql $i >> tramiT.dat
        done

SQL>
SQL> select * from hello;

         X Y
---------- --------------------
         1 Str - 1
         2 Str - 2
         3 Str - 3
         4 Str - 4
         5 Str - 5
         6 Str - 6
         7 Str - 7
         8 Str - 8
         9 Str - 9
        10 Str - 10

10 rows selected.

SQL>
SQL>

$
$
$ cat -n file_to_read
     1  00#AA#1#xx
     2  00#AA#2#xx
     3  00#AA#3#xx
     4  00#AA#4#xx
     5  00#AA#5#xx
     6  00#AA#6#xx
$
$
$ cat -n example.sh
     1  #!/usr/bin/bash
     2  (
     3    echo "select * from hello where x in ("
     4    awk -F# '{ x = NR == 1 ? "" : ","; print x, "'\''"$3"'\''" }' file_to_read
     5    echo ");"
     6  ) > file.sql
     7
     8  sqlplus -s test/test <<EOF > tramit.dat
     9  set feed off timing off
    10  @file.sql
    11  exit
    12  EOF
$
$

$
$
$ ./example.sh
$
$ cat file.sql
select * from hello where x in (
 '1'
, '2'
, '3'
, '4'
, '5'
, '6'
);
$
$
$ cat tramit.dat

         X Y
---------- --------------------
         1 Str - 1
         2 Str - 2
         3 Str - 3
         4 Str - 4
         5 Str - 5
         6 Str - 6
$
$