Re: [NEWBIE] SQLLOADER - Load from multiple files

Andy wrote:

> Daniel and DB,
>
> Why don't you dynamically create the control file at runtime? For example:
>
> echo "LOAD DATA" > dyn_control.ctl
> for datafile in `ls *.dat`; do
> echo "INFILE $datafile" >> dyn_control.ctl
> done
> echo "INTO TABLE table1 ...." >> dyn_control.ctl
>
> Andy

There is a demo of dynamically created control files at http://www.psoug.org

Click on Morgan's Library
Click on UTL_FILE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)