locked
Bulk update/cursor RRS feed

  • 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.

    Friday, September 23, 2016 6:22 PM

All replies

  • User364663285 posted

    Hi,

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

    Thursday, September 29, 2016 7:22 AM