title: Add DB timestamp to SQL Loader CSV import
body: <p>I have a client who's CSV file does not contain any dates.  They would like a timestamp to indicate as to when each row is loaded into their Oracle 11g database.  The CSV file is being supplied by a vendor so I cannot modify the file.  I have tried adding a default column value and an "after insert" trigger but with no luck. (Performance is not an issue as this is an off- hours process).</p>
  
  <p>The control files looks like this:</p>
  
  <pre><code>options (skip=1, direct=true, rows=10000)
  load data
   infile data.dat
  badfile sqldatatxtdata.bad
  replace
       into table LAM.CSV_DATA_TXT
  fields terminated by ','
  trailing nullcols
  (ASSET, ASSET_CLASS, MATURITY, PRICE)
  </code></pre>
  
  <p>The table looks like such:</p>
  
  <pre><code>create table LAM.CSV_DATA_TXT  (
  ASSET   VARCHAR2(20),
  ASSET_CLASS   VARCHAR2(50),
  MATURITY  varchar2(50),
  PRICE  NUMBER(12,8),
  DATE_TIMESTAMP DATE default(SYSTIMESTAMP) 
  </code></pre>
  
  <p>Any other ideas?  Thanks.</p>