RE: Pl/sql loop assistance

2001-05-11 Thread Steve Adams
Hi Jacques, It is not reliable if there is row migration. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 11 May 2001 3:07 To: Multiple recipients of list ORACLE-L > -Original Message- > From: Jared

Re: Pl/sql loop assistance

2001-05-10 Thread Jared Still
On Thursday 10 May 2001 10:06, Jacques Kilchoer wrote: > This reminds me, Mr. Still, you posted an example once to the list about > doing a fetch in rowid order to avoid revisiting the same block when doing > a full table scan of a table, so that reading and updating every row in a > table would a

RE: Pl/sql loop assistance

2001-05-10 Thread Jacques Kilchoer
Title: RE: Pl/sql loop assistance > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > > I'll have to disagree with not using commit within a loop. > > If you identify what a transaction is within your code, and > write it accor

Re: Pl/sql loop assistance

2001-05-10 Thread paquette stephane
> > > where campaign_response_handled != > 1 > > > > > and rownum <= 100 > > > > > and docalert_response_id in > (select > > > > > docalert_response_id > > > > >from > docalert_email

Re: Pl/sql loop assistance

2001-05-09 Thread Jared Still
d in (select > > > > docalert_response_id > > > >from docalert_emails_050401@ncc > > > >where sent = 1); > > > > commit; > > > > exit when sql%notfound; > > >

Re: Re[2]: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
> > > commit; > > > > exit when sql%notfound; > > > > end loop; > > > > end; > > > > / > > > > > > > > Diana Duncan > > > > TITAN Technology Partners > > > > One Copley Parkway, Ste

Re: Pl/sql loop assistance

2001-05-09 Thread Diana_Duncan
AIL PROTECTED] Subject: Re: Pl/sql lo

Re[2]: Pl/sql loop assistance

2001-05-09 Thread dgoulet
> > commit; > > > exit when sql%notfound; > > > end loop; > > > end; > > > / > > > > > > Diana Duncan > > > TITAN Technology Partners > > > One Copley Parkway, Ste 540 > >

Re: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
te 540 > > > Morrisville, NC 27560 > > > VM: 919.466.7337 x 316 > > > F: 919.466.7427 > > > E: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > "Hagedorn, > > > >

Re: Pl/sql loop assistance

2001-05-09 Thread Jared Still
; > > > "Hagedorn, > > > > > > Linda" To: > > Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > > > > >

Re: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
> > Linda" To: > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > >

Re: Pl/sql loop assistance

2001-05-08 Thread Diana_Duncan
Fax to: Sent by: Subject: Pl/sql loop assistance

Pl/sql loop assistance

2001-05-08 Thread Hagedorn, Linda
Title: Pl/sql loop assistance Hello, I'm having difficulty coding this loop and am hoping someone can see how this can be done.   I have two tables, one on each instance reg.docalert_responses@ncp and reg.docalert_emails_05040@ncc The requirement is t