title: concatenate multiple fields in sqlldr
body: <p>I am working on sqlldr(sql loader) in oracle 11g.
  I am trying to concatenate 3 fields into a single field. Has anyone done this?</p>
  
  <p>ex: 
  TABLE - "CELLINFO" where the fields are (mobile_no,service,longitude).</p>
  
  <p>The data given is (+9198449844,idea,110,25,50) i.e. (mobile_no,service,grad,min,sec).</p>
  
  <p>But while loading data into the table i need to concatenate the last 3 fields (grad,min,sec) into the longitude field of the table.</p>
  
  <p>Here i cant edit manually because i have 1000's of data to be loaded.</p>
  
  <p>I also tried using ||,+ and concat().... but I am not able to.</p>