-- lets check the table

bash-2.03$ sqlplus -s mag/mag << EOF
> select * from member;
> exit;
> EOF

no rows selected

-- lets run the shell script

bash-2.03$ sample

invoking the sql*loader
using table member

SQL*Loader: Release 9.2.0.4.0 - Production on Fri Aug 13 09:42:22 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 4

-- lets check whether records are loaded

bash-2.03$ sqlplus -s mag/mag << EOF
> select * from member;
> exit;
> EOF

NAME       ADDRESS
---------- --------------------
Charlie    250yonge
Ben        123King
Ben        123king
Peter      5Brook

--
-- this is the script.
-- 

bash-2.03$ cat sample
#!/usr/bin/bash
intable=member
echo load data                                    > temp1.ctl
echo infile 'member.dat'                         >> temp1.ctl
echo replace into table $intable                 >> temp1.ctl
echo fields terminated by ',' trailing nullcols  >> temp1.ctl
echo (name,                                     >> temp1.ctl
echo address)                                    >> temp1.ctl
echo
echo invoking the sql*loader
echo using table $intable
sqlldr userid=mag/mag control=temp1.ctl