Pl sql blocks improves readability of course. More over when you insert new code in an existing procedire,it is better to have a declare begin end block. Because the variables you declare here will be local and will not conflict with the variables with the same names n the main program .
regards Gopa On Nov 30, 2010 9:51 AM, "Richard Pascual" <richg...@gmail.com> wrote: Michael: Thanks for the tip. I like the practice of naming nested pl/sql blocks as it eases readability... <<response>>a most definitely useful approach; end response; Gopa: You may not have seen my follow up post to my original question but it seems that your findings or understanding of this "bubble effect" confirms what I discovered in the Oracle documentation. Thanks for your reply. Rich Pascual On Mon, Nov 29, 2010 at 7:38 PM, Gopakumar Pandarikkal < pandarik...@gmail.com> wrote: > > As the ... -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
