title: How to check which rows has been generated error while import data from Excel file to the table in Oracle
body: <p>I have an Excel file with 10,000 records. I want to import this file into a table in an Oracle database. But I found some error while importing the data. </p>
  
  <p>How can I check which records has been generate as error while import?</p>
  
  <p>Here is the code to import-</p>
  
  <pre><code>load data infile D:\WORKOUT\SD.csv
  into table md.cus
  field terminated by ','
  trailing nullcods
  ( orderdate =&gt; orderdate,
    region =&gt; region,
    rep =&gt; rep,
    item =&gt; item,
    units =&gt; units,
    unitcost =&gt; unitcost,
    total =&gt; total);
  </code></pre>