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

Oracle SQL 12c
  • 13 Videos | 1h 12m 53s
  • Includes Assessment
  • Earns a Badge
Likes 30 Likes 30
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.

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
    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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Data Conversion
Likes 33 Likes 33  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 41 Likes 41  
COURSE Customizing Output
Likes 53 Likes 53  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Likes 36 Likes 36  
COURSE Oracle Database 12c R2 SQL: Restricting & Sorting Data
Likes 16 Likes 16  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 41 Likes 41