#!/bin/sh db_user=scott db_pwd=oracle send_day=`sqlplus -s $db_user/$db_pwd<< EOF set trimspool on set trimout on set linesize 2000 set pagesize 0 set heading off set termout off set feedback off spool sp_test.txt select empno||','||deptno||','||ename from emp; spool off / EOF` end_sqlldr=`sqlldr scott/oracle control=input.ctl data=sp_test.txt log=1.log bad=1.bad`