O'Reilly logo

Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database by Jason Price

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 4Using Simple Functions

In this chapter, you’ll learn about some of the Oracle database’s built-in functions. A function accepts zero or more input parameters and returns an output parameter. There are two main types of functions you can use in an Oracle database:

Image Single-row functions operate on one row at a time and return one row of output for each input row. An example single-row function is CONCAT (x, y), which appends y to x and returns the resulting string.

Image Aggregate functions operate on multiple rows at the same time and return one ...

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