Re: PL/SQL best practices ? How to go to end of loop (i.e. next record)
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 9 Feb 2011 15:59:31 -0600 (CST)
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
