Re: PL/SQL best practices ? How to go to end of loop (i.e. next record)
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 10 Feb 2011 08:21:05 +0000
Message-ID: <AANLkTi=HoF6kRqvsdJ88qOuwpS+-TyyNeq3ePZOiy3Hm_at_mail.gmail.com>
That's got my vote.
Date: Thu, 10 Feb 2011 08:21:05 +0000
Message-ID: <AANLkTi=HoF6kRqvsdJ88qOuwpS+-TyyNeq3ePZOiy3Hm_at_mail.gmail.com>
That's got my vote.
On 9 Feb 2011 23:00, "Stephane Faroult" <sfaroult_at_roughsea.com> 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...
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 10 2011 - 02:21:05 CST