I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above.
The workbook should be in a .XLS format. If a particular select statement retrieves more than a 500,000 rows, the script should notify user to revisit the statement.
I need urgent help to implement this ... and my efforts to write one has stopped at one point...Just getting the input{see below}...dnt know how to implement the execution and formatting as required above....
#!/bin/bash
# Number=0
echo "Welcome !!! Do you wish to run a select query?"
select yn in "Yes" "No"; do
case $yn in
Yes ) break;;
No ) exit;;
esac
done
echo "Enter the number of queries to be run : "
read Number
echo "Enter the schema owner name: "
read user
echo "Enter the password: "
stty_orig=`stty -g`
stty -echo
read paswd
stty $stty_orig
LOWER_LIMIT=1
UPPER_LIMIT=20
declare -a Queries
echo "Enter the queries in sequence to be run \n"
# Initialize the array.
i=0
while [ "$i" -lt "$Number" ]
do
echo " Enter query$LOWER_LIMIT : "
read query
Queries=$query
let "i += 1"
let "LOWER_LIMIT += 1"
done
\n\n\n
echo "Query execution in progress... Please be patient"