Re: Need help performing large updates...
From: Bo Lu <bo.lu_at_hsc.utah.edu>
Date: 1996/04/09
Message-ID: <4kcalo$rbu_at_news.cc.utah.edu>#1/1
Date: 1996/04/09
Message-ID: <4kcalo$rbu_at_news.cc.utah.edu>#1/1
I run into this problem several month ago. Instead of do the update within ONE SQL statement, you use PL/SQL to do the update for each records. You can setup a counter and commit each 10,000 records.
-- Bo Lu Programmer/Analyst Hospital and Clinical Informatics, U. of Utah Phone: 801-581-5964, E-Mail: bo.lu_at_hsc.med.utah.eduReceived on Tue Apr 09 1996 - 00:00:00 CEST