title: sqlldr insert multiple files into multiple tables with one control file
body: <p>Can I use one control file to insert data into multiple tables from multiple files? Like:</p>
  
  <pre><code>load data
  INFILE 'C:\Users\shu37\Desktop\emp.csv'
  INTO TABLE Emp
  TRUNCATE
  FIELDS Terminated By ',' OPTIONALLY ENCLOSED BY '"'
  (EmpId,EmpName)
  INFILE 'C:\Users\shu37\Desktop\dept.csv'
  INTO TABLE department
  TRUNCATE
  FIELDS Terminated By ',' OPTIONALLY ENCLOSED BY '"'
  (DId,DName)
  </code></pre>
  
  <p>I have like 500 tables which I want to import data from a equally number of CSVs (one CSV per table) and I can't write 500 control files.</p>
  
  <p>Even though I write I need a superscript to run all 500 control files in a loop, which seems a bit inefficient. </p>
  
  <p>I'm sure there should be a way to do this with SQLDLR.</p>
  
  <p>Any ideas?</p>