Generate Excel | CSV Report from SQL*PLUS

Shell Script to generate a column seperator report in SQL*PLUS using a shell script. It can be opened in Excel and or text editor like NOTEPAD++   #!/bin/ksh . $HOME/.bash_profile NOW=$(date +”%a %b %e %T %Y”) HOST=$(hostname) MON2=$(date +”%b%Y”) cd $HOME/scripts rm -rf Report_$MON2.csv sqlplus -s /NOLOG << EOF > /tmp/log.txt CONNECT abc/***** set colsep … Continue reading Generate Excel | CSV Report from SQL*PLUS