Images

CHAPTER 8

Single-Row and Conversion Functions

Exam Objectives

In this chapter, you will learn to

• 061.3.1    Describe Various Types of Functions Available in SQL

• 061.3.2    Use Character, Number, and Date Functions in SELECT Statements

• 061.4.1    Describe Various Types of Conversion Functions That Are Available in SQL

• 061.4.2    Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions

• 061.4.3    Apply Conditional Expressions in a SELECT Statement

The functions discussed in this chapter are commonly used built-in PL/SQL programs, packaged and supplied by Oracle. Some operate on numeric, date, and character data, while others convert ...

Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition 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.