Re: Update Query Question

From: Noodles <noodles_at_aol.com>
Date: 22 Aug 1999 16:24:20 GMT
Message-ID: <19990822122420.27929.00000391@ng-xb1.aol.com>

Look into PL/SQL. Basically, you would open a cursor and perform your SQL select. Then you fetch values from that cursor into some variables and then perform your insert. You can buffer your commits so that you don't fill up your rollback segment.

I'm using this logic in moving data from legacy system into a new table and each PL Procedure is about 20 lines long. Performance-wise I can update 500000 records in about 4 minutes. ( HP 10.x running 8.0.5 )

Respond if you need some example code. Received on Sun Aug 22 1999 - 11:24:20 CDT