22
Stored Code Advanced Concepts
In the previous three chapters, you explored various concepts of stored code in PL/SQL. You learned how to create stand-alone functions and procedures as well as how to combine them into packages.
In this chapter, you will continue to learn about stored code and explore some of the advanced options supported in PL/SQL, such as how to overload subprograms, utilize the RESULT_CACHE option with functions, create pipelined table functions, and utilize SQL macros.
Lab 22.1: Subprogram Overloading
When you overload subprograms, ...
Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
