Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL question

RE: PL/SQL question

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 28 Sep 2005 08:39:45 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FC63@EXCNYSM0A1AJ.nysemail.nyenet>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hallas, John, Tech
Dev
Sent: Wednesday, September 28, 2005 7:32 AM To: davidsharples_at_gmail.com; manoj.gurnani_at_polaris.co.in Cc: oracle-l_at_freelists.org
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_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 - 07:42:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US