Log-In to post
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.
Your book Oracle PL/SQL pocket reference is really nice i have gone through it.We need some more books like this one.
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?