title: load data using sql loader
body: <p>Need a quick help.
  I have a file which contains huge pipe separated data.
  I want to load each line of the data file to a column in a table.
  But each line in data file is having multiple pipes.
  previoulsy while loading data I was loading to multiple columns using pipe as delimiter using below control file query. </p>
  
  <pre><code>LOAD DATA 
  INTO TABLE sc8157.tmp_analysis_01
  APPEND 
  FIELDS TERMINATED BY '|' 
  TRAILING NULLCOLS 
  (
    ABD_ERRORMESSAGE,
    ISSUE_NO CONSTANT 'FIT-33266_all'
  )
  </code></pre>
  
  <p>But now I want to load entire line to one column. Can anyone help me in writing the query for the control file?
  Thanks in advance.</p>