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
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
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
> > > where campaign_response_handled !=
> 1
> > > > > and rownum <= 100
> > > > > and docalert_response_id in
> (select
> > > > > docalert_response_id
> > > > >from
> docalert_email
d in (select
> > > > docalert_response_id
> > > >from docalert_emails_050401@ncc
> > > >where sent = 1);
> > > > commit;
> > > > exit when sql%notfound;
> > >
> > > commit;
> > > > exit when sql%notfound;
> > > > end loop;
> > > > end;
> > > > /
> > > >
> > > > Diana Duncan
> > > > TITAN Technology Partners
> > > > One Copley Parkway, Ste
AIL PROTECTED] Subject: Re: Pl/sql lo
> > commit;
> > > exit when sql%notfound;
> > > end loop;
> > > end;
> > > /
> > >
> > > Diana Duncan
> > > TITAN Technology Partners
> > > One Copley Parkway, Ste 540
> >
te 540
> > > Morrisville, NC 27560
> > > VM: 919.466.7337 x 316
> > > F: 919.466.7427
> > > E: [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
> > >
> > > "Hagedorn,
> > >
>
; >
> > "Hagedorn,
> >
> >
> > Linda" To:
> > Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > >
> >
> >
>
> Linda" To:
> Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
>
>
>
Fax to:
Sent by: Subject: Pl/sql loop assistance
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
13 matches
Mail list logo