title: A way to update data in Oracle
body: <p>I have a table that I need to update each day. The data comes in a text file every time. I wrote a program that extracts the data from the text file and and writes it in the table, but now I want to modify it to just update the existing data. The data is mostly the same, it might differ only a few things. </p>
  
  <p>I was thinking about <code>MERGE</code> but I don't know very well how I could use this in my program. All the examples that I saw used a second table.</p>
  
  <p>So it would be like creating a second table in which I extract the current data, after which I make the merge into the old table to update the records. I want to avoid creating a second table, so I was wondering if there is any way to do this?</p>
  
  <p>Thanks!</p>