View source for Bash/SQLPlus/Input/Redirect

<source lang="bash">
# any where of the bash file can be placed this script
SYSPWD=oracle;\
echo "Oracle SQLPlus Multi-Line Input";\
(cat<<EOF
drop user academia_dev cascade;
create user academia_dev identified by academia_dev;
grant connect, resource, dba to academia_dev;
exit;
EOF
)|sqlplus -s sys/$SYSPWD as sysdba;\
ls -la;\
pwd
</source>

<source lang="bash">
# only at the end of bash file can be place this script
SYSPWD=oracle;\
echo "Oracle SQLPlus Multi-Line Input";\
sqlplus -s sys/$SYSPWD as sysdba <<EOF
drop user academia_dev cascade;
create user academia_dev identified by academia_dev;
grant connect, resource, dba to academia_dev;
exit;
EOF
</source>