Hello,
I think I have a simple question, but it's driving me crazy. I have to update a column in a table that has 97 million rows. The update is basically set status=Y where status=X. I'm trying to do a plsql block that will keep a counter, and commit after every 1000 records, but I can't get it right. I'm not sure if I need a cursor to do it or what, but it's not working. Anybody have a canned solution?
Mike
I think I have a simple question, but it's driving me crazy. I have to update a column in a table that has 97 million rows. The update is basically set status=Y where status=X. I'm trying to do a plsql block that will keep a counter, and commit after every 1000 records, but I can't get it right. I'm not sure if I need a cursor to do it or what, but it's not working. Anybody have a canned solution?
Mike