Re: Need help performing large updates...

  Some of the responses that I have seen say to use a large roll back statement, this is fine if you have the room. But most of us don't have that. You can write SQL that writes SQL. I would write a statement that goes like the following:

select 'udpate foo set bar = '||new_values||' where bar = '||old_value||';'

So if you have 500,000 this would give you 500,000 individual select statements. You could also do a commit after each statement if needed. If you need further help let me know. Received on Thu Apr 11 1996 - 00:00:00 CEST