RE: PL/SQL question

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 28 Sep 2005 12:31:33 +0100
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F0EE0@UKWMXM04>

If you have been on this list for a while you know what a lakh is

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: 28 September 2005 12:22
To: manoj.gurnani_at_polaris.co.in
Cc: oracle-l_at_freelists.org
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_at_polaris.co.in <manoj.gurnani_at_polaris.co.in > 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 28 2005 - 06:34:08 CDT