Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)

Chapter 5. Single Row Functions

Terms You Need to Understand

• ✓ Single row function

• ✓ String function

• ✓ Datetime function

• ✓ Conversion function

Concepts You Need to Master

• ✓ Single row functions

• ✓ Differences between string, number, datetime, and conversion functions

• ✓ Where functions can be used

• ✓ Nesting functions in other functions

• ✓ Number conversion function formatting

• ✓ Date conversion function formatting

This chapter describes single row functions. Single row functions operate within or as expressions on each row of a SQL statement. By definition, a function is a piece of compiled or interpreted code used to do some processing and return a value. Because a function returns a value, it can be embedded into an expression.

What Is a Function?

A function ...