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
 StevenFeuerstein.com
 Coding Therapy Video Sessions
 Real Automated Code Testing for Oracle Blog
 The PL/SQL Challenge
 Trainings, Seminars, and Presentations
 Steven's Personal Blog
 The PL/SQL Channel
 PL/SQL Standards
 I Love PL/SQL and ...
 PL/SQL Tips
 Companion Files for Training (DEMO.ZIP)
Updated Nov 19, 2013
 Steven Feuerstein's PL/SQL Books


 

65132 2 /
Follow / 7.10.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 / 11.21.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?  

Thanks,

Paul