Previous Page

Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions

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