Last post Sep 29, 2016 07:22 AM by wmec
Sep 23, 2016 06:22 PM|sushsudh|LINK
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.
Sep 29, 2016 07:22 AM|wmec|LINK
Within Spreadsheet, you can use VBA to generate relevant insert/update statement per relevant column details given.