title: Manipulating 15.000+ rows in Oracle
body: <p>I'm working on an application that requires a lot of data. This data is stored in SAP (some big enterprise planning tool) and needs to be loaded in an Oracle database. The data I'm talking about is 15.000+ rows long and each row has 21 columns.</p>
  
  <p>Every time an interaction is made with SAP (4 times a day), those 15.000 rows are exported and have to be loaded in the Oracle database. I'll try to explain what I do now to achieve my goal:</p>
  
  <ol>
  <li>Export data from SAP to a CSV file</li>
  <li>Remove all rows in the Oracle database</li>
  <li>Load the exported CSV file and import this into the Oracle database</li>
  </ol>
  
  <p>What you can conclude from this is that the data has to be updated in the Oracle database if there is a change in the row. This process takes about 1 minute.</p>
  
  <p>Now I'm wondering if it would be faster to check each row in the Oracle database for changes in the CSV file. The reason why I ask this before trying it first is because it requires a lot of coding to do what my question is about. Maybe someone has done something similar before and can guide me with the best solution.</p>