Here is a little header that I like to use for my shell scripts for Oracle code,
feel free to suggest mods

[code language=”sql”]

#!/bin/ksh
############################################################################
# Script Name..: <script name>.ksh
# Description..:
# Author…….: Michael Culp
# Date………: 04/ /2013
# Version……:
# Modified By..:
# Date Modified:
# Comments…..:
# Schema owner.:
#              : alter session set current should be used to change schemas
# Login User…:
# Run Order….:
# Dependent on.:
# Script type..:
# ############################################################################
sqlplus -s "/ as sysdba" &lt;&lt;EOF
set lines 150
set pages 150
— spool &lt;some file name&gt;
— spool off
EOF
[/code]