title: data not getting populated from sql loader
body: <p>I have a control file, loader.ctl, in <code>C:\oracle\product\10.2.0\oradata\orcl</code>.</p>
  
  <p><strong>Content of loader.ctl file is</strong> </p>
  
  <pre><code> load data
   infile 'd:\mydata\test.csv'
   into table emp1
   fields terminated by "," optionally enclosed by '"'          
   ( empno, ename,job,mgr,hiredate,sal,comm,deptno )
  </code></pre>
  
  <p><code>emp1</code> table is already present in the database and there are 9 records in test.csv</p>
  
  <p>I executed loader.ctl from sqlldr:</p>
  
  <p><img src="https://i.stack.imgur.com/QIsPm.jpg" alt="enter image description here"></p>
  
  <p>Now, when I check my database I find no records in <code>emp1</code>... why is this so? After the commit why is the data not being populated in the table?</p>