PL/SQL Obsession - Oracle Wiki - Oracle - Toad World

PL/SQL Obsession

Oracle Community

PL/SQL Obsession

Oracle PL/SQL is a powerful database programming language purpose-built to extend the Oracle SQL language. PL/SQL makes it far easier to build highly secure, high performance, very maintainable applications on top of Oracle Database.

This page contains resources to help you write better PL/SQL code, faster.

PL/SQL Education Blogs Websites
 Practical Best PL/SQL Video Series
 PL/SQL Obsession Blog
 The PL/SQL Challenge
 Coding Therapy Video Sessions
 Real Automated Code Testing for Oracle Blog
 I Love PL/SQL and ...
 PL/SQL Standards
 PL/SQL Tips

 Steven Feuerstein's PL/SQL Books

86040 2 /
Follow / 10 Jul 2013 at 1:41pm

HI Steven,

Your book Oracle PL/SQL pocket reference is really nice i have gone through it.We need some more books like this one.

Ahmad Khan

Follow / 21 Nov 2013 at 12:59am

Hi Steven,

At Tuesday's Power of Names webinar, you asserted that nesting procedures within procedures within procedures (I believe you said even five levels deep) was often useful and briefly showed us some code utilizing this deeply nested structure.  I've been mulling it since and still am not sure I see the utility.  I'd balance the gain of "complexity hiding" verses the loss of having an uncertain scope in these trees of subprocedures (seems like you could create a real mess referencing blindly up and down the tree).  But that being said I was intrigued by your code snippet where it seem like you were referencing multiple levels of the tree via some kind of indices?  It came and went.  Any chance you could post the snippet or just explain what it was about?