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

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: sfaroult@xxxxxxxxxxxx
  • Date: Thu, 10 Feb 2011 08:21:05 +0000

That's got my vote.

On 9 Feb 2011 23:00, "Stephane Faroult" <sfaroult@xxxxxxxxxxxx> wrote:

 What about

    for cur1 in (SELECT blablabla where != something_I_dont_like)
   end loop

And if your code contains several inserts, I would take a look at multi
table inserts.
The fewer loops, the better.

Stephane Faroult
RoughSea Ltd <>
Konagora <>
RoughSea Channel on Youtube <>

On 02/09/2011 10:45 PM, Michael Moore wrote:
> I can think of many ways to do this but is there a...

Other related posts: