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

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)
    loop
      code
   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 <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>


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: