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.
