C:>runsqlldr member.ctl

SQL*Loader: Release 8.1.6.0.0 - Production on Tue Jan 13 15:39:57 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 3

C:>query member

Table: member

CONTROL_ID NAME         ADDRESS
---------- ------------ ------------------------------
        80 Charlie       250 yonge st
        80 Peter         5 Brookbanks dr
        80 Ben           123 King st

3 rows selected.

C:>cat runsqlldr.bat
@echo off
:loop
if "%1"=="" GOTO continue
        sqlldr userid=mag/mag@mutation control=%1
        goto End
        :End
SHIFT
GOTO Loop
:continue

C:>cat member.ctl
load data
infile 'member.dat'
insert into table member
fields terminated by ','
(
control_id constant '80',
name,
address
)
C:>cat member.dat
Charlie, 250 yonge st
Peter, 5 Brookbanks dr
Ben, 123 King st