Re: PL/SQL best practices ? How to go to end of loop (i.e. next record)
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 9 Feb 2011 15:59:31 -0600 (CST)
Message-ID: <bfa648641de71eca117d213e0d00fd34.squirrel_at_society.servebeer.com>
Hey Michael,
Date: Wed, 9 Feb 2011 15:59:31 -0600 (CST)
Message-ID: <bfa648641de71eca117d213e0d00fd34.squirrel_at_society.servebeer.com>
Hey Michael,
> I can think of many ways to do this but is there a definitive best practice?
> I'm sure there must be articles on this somewhere, so links as well as
> comments are appreciated.
Toadworld.com has Quest's Best Practices online, including a section on PL/SQL iteration:
http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/PTOC34/Default.aspx
Thankfully there's a note that recommends avoiding the "GOTO" statement!
HTH! GL! Rich (the [TeamT] one, if this is the same MJM from the Toad groups)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 09 2011 - 15:59:31 CST