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:
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.
Aggregate functions operate on multiple rows at the same time and return one ...
Get Oracle Database 11g SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
