title: Mapping fields in Oracle SQL Loader
body: <p>When loading an external csv with Oracle SQL Loader is there a way to map the fields directly to each other in the control file?</p>
  
  <p>At the moment I'm doing a simple loading, so the position of the source fields is important. Is there a way to do it otherwise? So instead of:</p>
  
  <pre><code>load data
  into table1
  fields terminated by "," optionally enclosed by '"'
  (destination_field1, destination_field2, destination_field3)
  </code></pre>
  
  <p>do something like:</p>
  
  <pre><code>load data
  into table1
  fields terminated by "," optionally enclosed by '"'
  (
  source_field2 =&gt; destination_field1,
  source_field1 =&gt; destination_field2,
  source_field3 =&gt; destination_field3
  )
  </code></pre>
  
  <p><strong>Edit:</strong></p>
  
  <p>The main reason is that the order of the columns in the source file can change, therefore I can't be sure which field will be the first, second, etc.</p>