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 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.

Start your free trial