Re: PL/SQL best practices ? How to go to end of loop (i.e. next record)

From: Tim Hall <tim_at_oracle-base.com>
Date: Thu, 10 Feb 2011 09:05:20 +0000
Message-ID: <AANLkTinjNOe-jZdEqJPq+EcKP8YAqF_CtR7JRJ-uSS=S_at_mail.gmail.com>

Nial: I think the point was how best to jump out of the current iteration of the loop.

Of course, not having the row there in the first place would be better, but that is not always possible. I suspect the OP simplified the code samples to the point where other solutions not relevant to the question became possible. :)

Cheers

Tim...

On Thu, Feb 10, 2011 at 8:31 AM, David Aldridge <david_at_david-aldridge.com> wrote:
> Fiddleage is where the science of research meets the art of implementation.
>
> ________________________________
> From: Niall Litchfield <niall.litchfield_at_gmail.com>
> To: david_at_david-aldridge.com
> Cc: Tim Hall <tim_at_oracle-base.com>; "oracle-l_at_freelists.org"
> <oracle-l_at_freelists.org>; michaeljmoore_at_gmail.com
> Sent: Thu, 10 February, 2011 8:21:05
> Subject: Re: PL/SQL best practices ? How to go to end of loop (i.e. next
> record)
>
> It's one of those irregular verbs  isn't it. I research new features, you
> fiddle with them, they just slap them in. :)
>
> On 10 Feb 2011 08:13, "David Aldridge" <david_at_david-aldridge.com> wrote:
>
> Ah, the perfect opportunity to fiddle with conditional compilation as well
> then.
>
> ________________________________
> From: Michael Moore <michaeljmoore_at_gmail.com>
> To: Tim Hall <tim_at_oracle-base.com>
> Cc: "jslowik_at_cps92.com" <jslowik_at_cps92.com>; "oracle-l_at_freelists.org"
> <oracle-l_at_freelists.org>
> Sent: Wed, 9 February, 2011 22:20:34
> Subject: Re: PL/SQL best practices ? How to go to end of loop (i.e. next
> record)
>
> Tim,
> We are almost on 11g. This is the perfect construct for my problem. Thanks!
> Regards,
> Mike
>
> On ...

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

Received on Thu Feb 10 2011 - 03:05:20 CST