title: Loading text file in oracle from unix system
body: <p>I am having text file contaning field in below manner.</p>
  
  <pre><code>"64252368","7489040","305762",
  "64285217","12132108","787341",
  </code></pre>
  
  <p>I am using a below control file.</p>
  
  <pre><code>OPTIONS (SKIP=1)
  LOAD DATA
  TRUNCATE INTO TABLE test_table
  FIELDS TERMINATED BY '",'
  
  (
          LEARNEVENT_ID,
          ORGANIZATION,
          COURSE_ID
  )
  </code></pre>
  
  <p>But, I am getting the error:</p>
  
  <pre><code>Record 1: Rejected - Error on table test_table, column LEARNEVENT_ID
  ORA-01722: invalid number
  </code></pre>
  
  <p>Kindly help me on it.</p>