February 2020
Intermediate to advanced
467 pages
8h 30m
English
Every programmer has at some point learned about modularization – splitting the code into smaller units each solving a distinct part of the whole, typically used in procedural languages as functions and procedures, like in PL/SQL. In SQL there are views to help reduce complexity and provide reusability.
But modularization does not necessarily mean globally accessible and reusable units. For example, in PL/SQL I can create local functions and procedures in the declaration section of another function or procedure. These code units have only local scope and do not exist ...
