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 ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) 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.
