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:
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.
Aggregate functions These operate on multiple rows at the same time ...
Get Oracle Database 10g 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.
