O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21 Packages

CHAPTER OBJECTIVES

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.

Lab 21.1 The Benefits of Using Packages

LAB OBJECTIVES

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required