in reply to Oracle mass update script request.
Why do you want to make life so miserable for yourself? Why not ask the database to do the update for you in one hit.
update table1 t1 set t1.field1 = 999 where exists ( select 1 from table2 t2 where t1.id = t2.id )
Then you just have to debug your SQL. No Perl needed apart from a $db->do(''), no bugs to look for! Not to mention faster...
• another intruder with the mooring in the heart of the Perl
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Oracle mass update script request.
by dbmathis (Scribe) on Jul 28, 2008 at 12:08 UTC | |
by roboticus (Chancellor) on Jul 28, 2008 at 12:16 UTC | |
by dbmathis (Scribe) on Jul 28, 2008 at 14:08 UTC |
In Section
Seekers of Perl Wisdom