title: Difference Between Insert and Append statement in SQL Loader?
body: <p>Can any one tell me the Difference Between Insert and Append statement in SQL Loader?consider the below example : 
  Here is my control file </p>
  
  <pre><code>     load_1.ctl
       load data 
       infile 'load_1.dat' "str '\r\n'" 
       insert*/+append/* into table sql_loader_1 
       ( 
        load_time sysdate, 
        field_2 position( 1:10),
        field_1 position(11:20)
       ) 
  </code></pre>
  
  <p>Here is my data file </p>
  
  <pre><code>     load_1.dat
       0123456789abcdefghij
       **********##########
       foo         bar
       here comes a very long line 
       and the next is 
       short 
  </code></pre>