Initial Script Template

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


#!/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" <<EOF 
set lines 150 
set pages 150 
-- spool <some file name>
-- spool off 
EOF

Leave a Reply

Your email address will not be published. Required fields are marked *