I've been on this list for years and don't know what a lakh is. Is this some kind of four legged creature that lives in the Alps? :-) ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hallas, John, Tech Dev Sent: Wednesday, September 28, 2005 7:32 AM To: davidsharples@xxxxxxxxx; manoj.gurnani@xxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: PL/SQL question If you have been on this list for a while you know what a lakh is ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples Sent: 28 September 2005 12:22 To: manoj.gurnani@xxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: PL/SQL question post your code, can take a look at in then (p.s. not many people will know what a lakh is, it isnt used apart from in the sub continent I believe) On 9/28/05, manoj.gurnani@xxxxxxxxxxxxx <manoj.gurnani@xxxxxxxxxxxxx > wrote: Hi, I've a cursor which retrieves about 3 lakh recs from a table.(master) based on column value retrieved from cursor for each rec,there are other tables (detail) to be updated. The detail tables have large volumes of data. the question is how can the performance be improved to achieve the desired result.