O'Reilly logo

Oracle Database 10g SQL 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 3Using 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 These 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 xand returns the resulting string.

Image Aggregate functions These operate on multiple rows at the same time ...

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