In this chapter, you will learn about
• Creating and using functions
A function that is stored in the database is much like a procedure in that it is a named PL/SQL block that can take parameters and be invoked. There are key differences both in how it is created and how it is used. This short chapter covers the basics of how to create, use, and drop a function. Chapter 21, “Packages,” shows you how to extend functions when they are placed in packages.
After completing this lab, you will be able to
• Create stored functions
• Make use of functions
• Invoke functions in SQL statements
• Write complex functions
Functions are another type ...