SQL Fundamentals, Third Edition

Chapter 10. Using Row Functions

In the last chapter, we discussed many of the most commonly used row functions. In this chapter, we discuss a few more row functions that are used for special purposes. We also discuss the documentation of row functions and show some of their applications.

Specialized Row Functions		363
10-1	Other row functions	363
10-2	Using a function to identify the user and the date	365
10-3	Using a function to change nulls to other values	366
10-4	Using a function to change the datatype	369
Using the Documentation of Row Functions		372
10-5	Using Oracle documentation	373
10-6	Using Access documentation	374
10-7	Using the Access Expression Builder to find row functions	375
Creating Patterns of Numbers and Dates		376
10-8	Create a simple pattern of numbers ...