RE: PL/SQL question
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <manoj.gurnani@xxxxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 12:31:33 +0100
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.
Other related posts: