Oracle PL/SQL by Example, 6th Edition

20

Functions

In this chapter, you will learn about

• Creating Nested Functions

• Creating Stand-Alone Functions

Just like a procedure, a function may be created in a PL/SQL block, at a schema level, or in a package. The main difference between a procedure and a function is that a procedure performs an action, whereas a function computes and returns a value. In this chapter, you will learn about creating nested and stand-alone functions.

Lab 20.1: Creating Nested Functions

After this lab, you will be able to

• Create Nested Functions

A function is another type of a subprogram. A function can accept one, many, or no parameters, and it must return a value. As a result, a function has a return data type specified in its header and a return clause ...