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