In Oracle, using TOAD, we are able to create an insert script from a table. 

However, I need to create an UPDATE script based on the values of each row 

```
where the CLIENTID is 'blah blah'

```

Originally, what I did was create an Excel spreadsheet with all the necessary data and for each row, I pasted a 

```
UPDATE TABLE BLAH BLAH SET COLUMN1 = "xxx", COLUMN2 = '' where CLIENT_ID = "123'

```

..but I ran into some difficulties with exporting the spreadsheet into a text based DOS file and converting it to a `.sql` as so to edit but it was messy and unpredictable.

Has anyone have a better idea I can implement?