title: load decimal into oracle table with sql loader
body: <p>I have this table in oracle :</p>
  
  <pre><code>CREATE TABLE mytable
  (
  TSTAMP  Date,
  prmc1 VARCHAR2(30),
  prmc2 VARCHAR2(30),
  prmc3 VARCHAR2(30),
  prmc4 VARCHAR2(30),
  prmc5 NUMBER,
  prmc5 NUMBER,
  prmc6 NUMBER
  )
  </code></pre>
  
  <p>the control file is below :</p>
  
  <pre><code>load data
  append
   into table mytable
  fields terminated by ',' TRAILING NULLCOLS
   ( tstamp DATE "YYYY-MM-DD HH24:MI" TERMINATED BY ",",
     prmc1 ":prmc1",
  prmc2 ":prmc2",
  prmc3 ":prmc3",
  prmc4 ":prmc4",
  prmc5 INTEGER  ":prmc5",
  prmc6 INTEGER  ":prmc6"
  )
  </code></pre>
  
  <p>the value of the column prmc5 in the csv file is -106.436</p>
  
  <p>how do i load this into the table?</p>