[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.
Chapter 3: Using Single-Row Functions discusses the single-row functions and conversion functions available, with details on how and where to use them.
- 4 Using Single-Row Functions to Customize Output
- 4.1 Describe various types of functions available in SQL
- 4.2 Use character, number, and date functions in SELECT statements
- 5 Using Conversion Functions and Conditional Expressions
- 5.1 Describe various types of conversion functions that are available in SQL
- 5.2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- 5.3 Apply conditional expressions in a SELECT statement
Reading Material