O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

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

CHAPTER OBJECTIVES

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.

Lab 20.1 Creating and Using Functions

LAB OBJECTIVES

After completing this lab, you will be able to

• Create stored functions

• Make use of functions

• Invoke functions in SQL statements

• Write complex functions

Function Basics

Functions are another type ...

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