Shell Programming and Scripting

#!/bin/bash

#Checks if dir exists and creates it if not

datedDir=`date +'%Y%m%d'`
mkdir -p $datedDir

#Sets the Log file name to passed in variable
logFile=${datedDir}/$1

set echo off
set verify off
set termout off
set feedback off

sqlplus -s DB/USER@PW << ENDOFSQL

set pagesize 0

spool $logFile

select * from all

spool off

ENDOFSQL

timeStamp=`date +'%Y%m%d%H%M%S'`


grep -v '[a-zA-Z^$]' ${logFile}.lst > ${logFile}_$timeStamp.dat

# removes the spooled file
rm ${logFile}.lst

touch ${logFile}_$timeStamp.rdy

exit;

SQL> select ........

data

### rows selected

sqlplus -s DB/USER@PW << ENDOFSQL
set echo off
 set verify off
 set termout off
 set feedback off
 
set pagesize 0
spool $logFile
select * from all
spool off

ENDOFSQL

set echo off
set show off
set term on
set heading off
set feedback off
set linesize 200
set pages 0