title: Creating an update script from Oracle using TOAD
body: <p>In Oracle, using TOAD, we are able to create an insert script from a table. </p>
  
  <p>However, I need to create an UPDATE script based on the values of each row </p>
  
  <pre><code>where the CLIENTID is 'blah blah'
  </code></pre>
  
  <p>Originally, what I did was create an Excel spreadsheet with all the necessary data and for each row, I pasted a </p>
  
  <pre><code>UPDATE TABLE BLAH BLAH SET COLUMN1 = "xxx", COLUMN2 = '' where CLIENT_ID = "123'
  </code></pre>
  
  <p>..but I ran into some difficulties with exporting the spreadsheet into a text based DOS file and converting it to a <code>.sql</code> as so to edit but it was messy and unpredictable.</p>
  
  <p>Has anyone have a better idea I can implement?</p>