Bulk update/cursor

Question

User496086301 posted

Using Toad 12.1

I have 30k update records in spreadsheet. how to use a cursor to update in a batch of 500/1000 and in the end I want to see 30k records updated instead of getting 1 row updated 30k times.

Answer 1

User364663285 posted

Hi,

Within Spreadsheet, you can use VBA to generate relevant insert/update statement per relevant column details given.