Chapter 2. Using Single-Row Functions

ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Using Single-Row Functions to Customize Output

    • Describe various types of functions available in SQL

    • Use character, number, and date functions in SELECT statements

  • Using Conversion Functions and Conditional Expressions

    • Describe various types of conversion functions that are available in SQL

    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

    • Apply conditional expressions in a SELECT statement

Using Single-Row Functions

Functions are programs that take zero or more arguments and return a single value. Oracle has built a number of functions into SQL, and these ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.