In this chapter, you will learn about
• The benefits of using packages
• Cursor variables
• Extending the package
A package is a collection of PL/SQL objects grouped under one package name. Packages include procedures, functions, cursors, declarations, types, and variables. Collecting objects into a package offers numerous benefits. In this chapter, you learn what these benefits are and how to take advantage of them.
After completing this lab, you will be able to
• Create package specifications
• Create package bodies
• Call stored packages
• Create private objects
• Create package variables and cursors
Using packages as a method to bundle your functions ...