9
Single-Row Functions
In this chapter:
What types of built-in functions are available?
What are single-row functions?
What are the categories of single-row functions?
How do functions work with queries?
What are the options when formatting strings, numbers, and dates?
What are data conversion functions?
How are functions combined?
This chapter uses the queries you have worked with in previous chapters and expands the way you can use columns by introducing functions. You will examine the types of functions used for different data types. Finally, you will experiment with combining functions together for more flexibility.
A function is a built-in PL/SQL program that always returns a single value. You can use the predefined functions (such as ...
Get Oracle 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.
