Shell Programming and Scripting

echo "Set up Oracle environment"
   PATH=/usr/local/bin:$PATH    ; export PATH
   ORAENV_ASK=NO                ; export ORAENV_ASK
   ORACLE_SID=server1        ; export ORACLE_SID
   . /usr/local/bin/oraenv
   echo "               Oracle_Home is $ORACLE_HOME"
   PATH=$ORACLE_HOME/bin:$PATH  ; export PATH
   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib ; export LD_LIBRARY_PATH

#Get value from configuration file
DB_INFO=$(<../dev2_config.txt)
export $DB_INFO

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib ; export LD_LIBRARY_PATH

while read connect_string
do
sqlplus -s  $connect_string <<-EOF
 select * from foo;
 exit
EOF
done < external_file

od -bc < ../dev2_config.txt

#Get oracle database credentials from configuration file
DB_INFO=`cat $parent/dev2_config.txt`
echo $DB_INFO