Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.
Expected Duration (hours)
1.1
Lesson Objectives Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions
describe the use of implicit and explicit data conversion within SQL statements
use the TO_CHAR function to convert a date to a character data type in a SQL statement
demonstrate elements of the Date Format Model in SQL
use the TO_CHAR function to convert a number to a character data type in a SQL statement
use the TO_NUMBER and TO_DATE functions to convert a character data type to a number or date format in a SQL statement
use the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in a SQL statement
describe general functions when working with data and how it pertains to NULL values
use the NVL and NVL2 functions when working with NULL values in a SQL statement
use the NULLIF and COALESCE functions when working with NULL values in a SQL statement
"describe conditional expressions to provide the use of the IF-THEN-ELSE logic in a SQL statement "
use the CASE expression to facilitate a conditional inquiry in a SQL statement
use the DECODE function to facilitate conditional inquiry in a SQL statement
apply conversions and conditional functions
Course Number: it_dfosfd_04_enus
Expertise Level
Beginner