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

Get Oracle Database 11g PL/SQL Programming Workbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.