Data Conversion

Oracle 12c    |    Beginner
  • 13 videos | 52m 45s
  • Earns a Badge
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.

WHAT YOU WILL LEARN

  • 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
    Describe elements of the date format model in  sql
    Use the to_char function to convert a number to a character datatype in a sql statement
    Use the to_number and to_date function 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 pertaining to null values
  • Use the nvl and nvl2 function when working with null values in a sql statement
    Use the nullif and coalesce functions when working with null values in a sql statement
    Use 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
    Write sql statements using the to_char, to_date, decode functions and the case expression

IN THIS COURSE

  • Locked
    1.  Implicit and Explicit Data Type Conversion
    4m 23s
    Upon completion of this video, you will be able to describe the use of implicit and explicit data conversion within SQL statements. FREE ACCESS
  • Locked
    2.  Using the TO_CHAR Function with Dates
    4m 6s
    In this video, you will use the TO_CHAR function to convert a date to a character data type in a SQL statement. FREE ACCESS
  • Locked
    3.  Date Format Model
    2m 52s
    After completing this video, you will be able to describe elements of the Date Format Model in SQL. FREE ACCESS
  • Locked
    4.  Using the TO_CHAR Function with Numbers
    5m 28s
    In this video, you will learn how to use the TO_CHAR Function to convert a number to a character data type in a SQL statement. FREE ACCESS
  • Locked
    5.  TO_NUMBER and TO_DATE Functions
    3m 47s
    In this video, learn how to use the TO_NUMBER and TO_DATE function to convert a character data type to a number or date format in a SQL statement. FREE ACCESS
  • Locked
    6.  Using TO_CHAR and TO_DATE with RR Date Format
    3m 27s
    In this video, find out how to use the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in an SQL statement. FREE ACCESS
  • Locked
    7.  General Functions
    2m 42s
    After completing this video, you will be able to describe general functions when working with data and how to handle NULL values. FREE ACCESS
  • Locked
    8.  NVL and NVL2 Functions
    5m 43s
    In this video, learn how to use the NVL and NVL2 functions when working with NULL values in a SQL statement. FREE ACCESS
  • Locked
    9.  NULLIF and COALESCE Functions
    5m 26s
    In this video, learn how to use the NULLIF and COALESCE functions when working with NULL values in SQL statements. FREE ACCESS
  • Locked
    10.  Conditional Expressions
    1m 52s
    Learn how to use conditional expressions to provide the IF-THEN-ELSE logic in a SQL statement. FREE ACCESS
  • Locked
    11.  CASE Expression
    4m 51s
    In this video, you will learn how to use the CASE expression to facilitate a conditional inquiry in a SQL statement. FREE ACCESS
  • Locked
    12.  Using the DECODE Function
    3m 57s
    In this video, you will learn how to use the DECODE function to facilitate conditional inquiry in a SQL statement. FREE ACCESS
  • Locked
    13.  Exercise: Use Functions and Conditional Expressions
    4m 11s
    Learn how to write SQL statements using the TO_CHAR, TO_DATE, DECODE functions and the CASE expression. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Restricting & Sorting Data
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 74 users Rating 4.6 of 74 users (74)
Course Introduction to SQL Bootcamp: Session 2 Replay
Rating 4.3 of 203 users Rating 4.3 of 203 users (203)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Customizing Output
Rating 4.7 of 168 users Rating 4.7 of 168 users (168)
Course Aggregating Data
Rating 4.7 of 152 users Rating 4.7 of 152 users (152)
Course Working with Joins
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)