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)
   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: