O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

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 5Functions

Functions are specialized program units or named blocks in PL/SQL. They can exist as solitary objects in your database schema. Standalone functions like these are also known as schema-level functions.

You can also deploy functions inside packages. (Chapter 2 discusses this concept, and Chapter 8 describes how packages work with functions and procedures.) When you define a function in a package specification, it becomes a published function and available for calls from other schema-level program units. If you opt to define functions in the package body, they become package-only functions. This makes them available to other functions and procedures in the package, but makes them inaccessible to external program units. Package ...

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