Wrapper script to run sql statements

Wrapper script to run any sql statement in all databases hosted on that server

runsql.sh

#!/bin/bash

echo "
<___________enter your title here___________>
"

export ORAENV_ASK='NO'

for ORACLE_SID in  <___________enter all SIDs, space seporated___________>
do

export ORACLE_SID
. oraenv > /dev/null

echo "
===============
$ORACLE_SID :
==============="

sqlplus -s / as sysdba @<___________enter your .sql file___________>  #it runs as sysdba, change login details as per your requirement.

echo "
===============================

Completed for the database $ORACLE_SID.

"
read -p "Press Enter to continue or Ctrl+c to exit ..."

done

unset ORAENV_ASK